PGNexus Daily News

PostgreSQL Technical Articles

PGConf India 2027 - Dates Announced and CFP Open

www.postgresql.org

PGConf India 2027 - Dates Announced and CFP Open

PGConf India 2027 is scheduled for March 2–5, 2027, at the Sheraton Grand Hotel at Brigade Gateway, Bengaluru. The Call for Papers is now open, with submissions closing October 15…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

pgstat: Flush some statistics within running transactions, take 2

Sami Imseih posted a rebase of the patch series for flushing PostgreSQL statistics within running transactions. The discussion references Michael's earlier refactoring work on pat…

Read Discussion
SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator

The discussion concerns a patch to detect integer overflow in the int8 accumulator used by SUM(int2) and SUM(int4). David Rowley proposed using PG_RETURN_INPUT(n) to reduce instru…

Read Discussion
hashjoins vs. Bloom filters (yet again)

Rui Zhao reports that patch v10 applies cleanly to current master, passes all 248 regression tests, and produces correct results across 480 query/GUC combinations. He identifies a…

Read Discussion
tablecmds: fix bug where index rebuild loses replica identity on partitions

A bug is reported where renaming a partition's index to a name that conflicts with an auto-generated name causes an error during `ALTER TABLE ... ALTER COLUMN ... TYPE`. The issue…

Read Discussion
Add wait events for server logging destination writes

The discussion covers a patch (v7) adding wait events for server logging destination writes (syslog, stderr, Windows console/eventlog). Seongjun Shin responds to Jakub Wartak's an…

Read Discussion
Collect ALTER PUBLICATION commands for event triggers

Shihao Zhong reviewed the v2 patch set for collecting ALTER PUBLICATION commands for event triggers. He tested v2 on master with asserts and noted that patch 0003 should be commit…

Read Discussion

Social Media Updates

linkedin

Team CYBERTEC will be at PgDay Lowlands coming Thursday!

CYBERTEC will have two representatives at PgDay Lowlands in Utrecht this Thursday: Peter Hofer, Chief Product Officer, and Christoph Berg, Senior PostgreSQL Engineer. Attendees ar…

Better AI agents need better context.

linkedin

Better AI agents need better context.

Databricks has launched the Certified Context Engineer Associate certification, designed to validate skills in curating context and building reliable, production-grade agentic AI…

On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch!

linkedin

On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch!

The author will be speaking at PGDay UK in London on Tuesday, 8th September, covering the topic of rebuilding a major PostgreSQL backup infrastructure from scratch. The talk relat…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more