Radiolab
• WNYC Studios
Postgres LISTEN/NOTIFY does not scale
I think this headline is justified. Recall.ai, a provider of meeting transcription bots, noticed that their PostgreSQL instance was being bogged down by heavy concurrent writes.After some spelunking they found this comment in the PostgreSQL source explaining that transactions with a pending notification take out a global lock against the entire PostgreSQL instance (represented by database 0) to ensure "that queue entries appear in commit order".
Moving away from LISTEN/NOTIFY to trigger actions on changes to rows gave them a significant performance boost under high write loads.
Via Hacker News
Tags: databases, performance, postgresql
The Atlas Obscura Podcast
• SiriusXM Podcasts & Atlas Obscura
A Seattle restaurant pushes diners to eat beyond their borders through its embrace of global street foods.
Hosted by Simplecast, an AdsWizz company. See pcm.adswizz.com for information about our collection and use of personal data for advertising.
Craig Mod: Overtourism in Japan, and How it Hurts Small Businesses. When your bar gets TikToked: “The only reason he opened the bar, he said, was so locals and friends like her would come. Now, all he had were customers he couldn’t talk to.”
“Lately, it has been difficult to ignore a tendency at the NY Times to make astonishingly bad news judgments. As Republicans increasingly circulate insane conspiracy theories and racist nonsense, the cult of centrism has taken a self-destructive turn.”
