PGNexus Daily News

Tom Lane submitted a patch fixing two bugs in PL/Perl: a null pointer dereference in hstore_plperl and an infinite loop in plperl when handling Perl tied objects. These were exclu…

Mats Kindahl responds to Denis Smirnov and Erik's slot-based batching proposal for the PostgreSQL executor. He agrees that TAM interface modifications are unnecessary and that TTS…

Tom Lane proposed replacing `tsqueryout()`'s hand-rolled extensible string buffer with the standard `StringInfo` abstraction, noting the original code was fragile and harder to re…

This GSoC 2026 thread discusses a proof-of-concept patch series for B-tree leaf page merging to reduce index bloat. Michail Sirotkin identified a bug where concurrent inserts coul…

The discussion centers on a bug in `gistkillitems` where LP_DEAD marking can target wrong tuples during a rescan. Peter Geoghegan notes the bug is likely introduced by commit `9c9…

The discussion concerns restructuring PostgreSQL's shared buffer hash table for performance. Heikki Linnakangas raised a concern that the buffer header spinlock is held too long d…