PGNexus Daily News

PostgreSQL Technical Articles

14,000x Faster Planning for LIMIT Queries on Hypertables

Sven Klemm

14,000x Faster Planning for LIMIT Queries on Hypertables

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

PostgreSQL Hackers Email Discussion Highlights

REPACK (ANALYZE) within transaction block segfaults

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
REPACK (CONCURRENTLY) doesn't check the table AM

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
Logical replication can lose an update after concurrent index invalidation

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
REPACK (CONCURRENTLY) fails when table owner lacks CONNECT

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
MERGE/SPLIT PARTITIONS issues/questions

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
pg_plan_advice: fix empty FOREIGN_JOIN sublist validation

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

Click here for the full Hacker discussion highlights

 

Industry News

OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats

techcrunch.com

OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats

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…
Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training

techcrunch.com

Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training

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…
Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others

techcrunch.com

Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others

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

Prototype to production is where compliance catches up with you.

linkedin

Prototype to production is where compliance catches up with you.

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 to learn more