PostgreSQL Technical Articles

rhaas.blogspot.com

Hacking Workshop for September 2026

Robert Haas announces a PostgreSQL hacking workshop scheduled for September 2026, featuring David Rowley as guest speaker. Rowley will present on optimizing code in performance-cr…

Read the Blog

www.postgresql.org

plRuby

plRuby is a new PostgreSQL procedural language extension that allows database functions to be written in Ruby. It embeds an MRI Ruby 3.x interpreter directly in the PostgreSQL bac…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

WAL compression setting after PostgreSQL LZ4 default change

The discussion focuses on changing the behavior of `wal_compression = 'on'` in PostgreSQL 19 so that it maps to lz4 (when available) instead of always using pglz. The goal is to a…

Read Discussion

pg19b1: TRAP: failed Assert("pgstat_bktype_io_stats_valid(bktype_shstats, MyBackendType)")

A failed assertion in `pgstat_bktype_io_stats_valid()` was triggered when non-zero IO time was recorded with a zero operation count, specifically for "foreign IO" waits in `WaitRe…

Read Discussion

pgstat: Flush some statistics within running transactions, take 2

Sami Imseih posted v2 of a patch enabling mid-transaction pgstat flushes. Bertrand Drouvot reviewed it and identified three issues: (1) calling pgstat_report_stat() mid-transactio…

Read Discussion

hashjoins vs. Bloom filters (yet again)

Tomas Vondra and Matheus Alcantara continue iterating on Bloom filter pushdown for hash joins. Matheus posted v9, incorporating six prior changes plus a key new fix: replacing `bl…

Read Discussion

walsummarizer can get stuck when switching timelines

Robert Haas has committed and back-patched a fix for an issue where the walsummarizer can get stuck when switching timelines. The patch went through at least three versions (v3 be…

Read Discussion

CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.

Jeff Davis posted a consolidated patch series addressing how CREATE SUBSCRIPTION handles connections, validation, and compatibility with pg_dump/restore. Key changes include: form…

Read Discussion

Industry News

techcrunch.com

Anthropic says its own AI models breached three companies during security tests

Anthropic has disclosed that its own AI models breached three companies during internal security tests. The revelation came after OpenAI's models reportedly broke into Hugging Fac…

techcrunch.com

Google nixes its Earth AI feature one day after launch amid misinformation criticism

Google pulled its Earth AI feature just one day after launch following swift public backlash. The tool allowed users to generate AI-created imagery and superimpose it over real Go…

techcrunch.com

Siri AI could come with a paywall for power users via iCloud+

Apple CEO Tim Cook has indicated that advanced Siri AI capabilities could become a paid feature for power users, integrated into the company's existing iCloud+ subscription tiers.…

Social Media Updates

Not every AI task deserves the same resources.

Unity AI Gateway allows organizations to route AI workloads based on their value and priority. Low-value tasks can be directed to cost-efficient open-source models, while high-val…

AI is changing what data teams are expected to build.

DataExpert.io founder Zach Wilson is launching a free six-hour Databricks boot camp starting August 3, aimed at data professionals adapting to AI-driven expectations. The curricul…

🕹️ Ubisoft needed to get game data to developers, designers, and applications faster.

Ubisoft struggled with slow data access due to a legacy Hadoop environment, fragmented tooling, and SQL-dependent workflows, leaving some teams waiting days for answers. By adopti…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates