PGNexus Daily News PostgreSQL Technical Articles [image: 14,000x Faster Planning for LIMIT Queries on Hypertables] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> Sven Klemm 14,000x Faster Planning for LIMIT Queries on Hypertables <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> TimescaleDB 2.30 introduces `DeferredChunkAppend`, a custom scan node that eliminates the per-chunk planning overhead for `LIMIT` queries on hypertables. Previously, queries like… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> PostgreSQL Hackers Email Discussion Highlights REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> Nathan Bossart reported that executing `REPACK (ANALYZE)` inside a transaction block (e.g., a DO block) causes a server crash with warnings about a non-empty SPI stack and an acti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> REPACK (CONCURRENTLY) doesn't check the table AM <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doesn't%20check%20the%20table%20AM> REPACK (CONCURRENTLY) replays changes via logical decoding from WAL, requiring the table AM to support logical decoding. Nathan Bossart noted that check_concurrent_repack_requirem… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doesn't%20check%20the%20table%20AM> Logical replication can lose an update after concurrent index invalidation <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20can%20...> A bug in logical replication is reported where an update can be silently lost following a concurrent index invalidation. The root cause lies in `FindLogicalRepLocalIndex()` and `R… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20can%20...> REPACK (CONCURRENTLY) fails when table owner lacks CONNECT <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> Nathan Bossart reported that `REPACK (CONCURRENTLY)` fails with a "permission denied" error when the table owner lacks CONNECT privilege on the database, because the REPACK decodi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> MERGE/SPLIT PARTITIONS issues/questions <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20i...> The discussion concerns the MERGE/SPLIT PARTITIONS feature, recently committed to PostgreSQL. Robert Haas raised serious concerns: the feature takes AccessExclusiveLock on the par… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20i...> pg_plan_advice: fix empty FOREIGN_JOIN sublist validation <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20empt...> A patch for `pg_plan_advice` was proposed to fix a bug in the validation of empty `FOREIGN_JOIN` sublists. Nathan Bossart asked Robert Haas for his opinion on the patch; Robert ap… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20empt...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-27-postgresql-daily-news-251.m...> Industry News [image: OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Some of the world's largest tech companies and AI startups — including OpenAI, Anthropic, and Google — have jointly called for action to address growing cybersecurity threats pose… [image: Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Meta's $18 billion settlement with 29 U.S. states contains a notable privacy trade-off: the agreement permits Meta to retain certain data collected from children under 13 to train… [image: Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Australian police have arrested two individuals in connection with the TeamPCP hacking group, which carried out a wave of cyberattacks targeting tech companies including Mercor an… Social Media Updates [image: Prototype to production is where compliance catches up with you.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Prototype to production is where compliance catches up with you. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> pgEdge, an enterprise Postgres solution, has achieved HIPAA readiness, covering its Cloud BYOC offering and self-hosted Enterprise Platform, building on existing SOC 2 Type II com… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more