PostgreSQL Technical Articles

Hans-Jürgen Schönig

Moving to pg_hardstorage without changing your recovery strategy

pg_hardstorage, an open-source PostgreSQL backup tool by CYBERTEC, supports gradual migration from existing backup solutions including pgBackRest, Barman, and WAL-G. The migration…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

log_min_messages per backend type

Alvaro Herrera proposed two small cleanup patches for the `log_min_messages` per-backend-type code. Patch 0001 refactors duplicate logic into a subroutine; patch 0002 simplifies m…

Read Discussion

Unexpected behavior after OOM errors

The thread discusses unexpected PostgreSQL behavior triggered by OOM (out-of-memory) injection errors. Michael Paquier applied a fix for `pgstat_get_entry_ref_cached()` (commit 16…

Read Discussion

hashjoins vs. Bloom filters (yet again)

Tomas Vondra posted v6 of a patch series for hashjoin Bloom filter pushdown. Key changes include merging earlier patches, fixing gaps in filter consideration for partial paths and…

Read Discussion

Checkpointer write combining

Melanie Plageman's v15 patch for checkpointer write combining combines up to io_combine_limit-sized write IOs by scanning for adjacent dirty buffers in shared memory. Benchmarks s…

Read Discussion

ci: namespace ccache by PostgreSQL major version

Jelte Fennema-Nio revised a patch to namespace ccache by PostgreSQL major version in the CI system. The update was initially drafted with Claude's assistance, then manually refine…

Read Discussion

Bypassing cursors in postgres_fdw to enable parallel plans

Robert Haas reviewed Rafia Sabih's rebased patches for bypassing cursors in postgres_fdw to enable parallel plans. Key issues raised include: the active_scan pointer should be cle…

Read Discussion

Industry News

techcrunch.com

Netflix Acquires Ben Affleck's AI Filmmaking Startup InterPositive for $587M

Netflix has revealed it paid $587 million in cash to acquire InterPositive, an AI filmmaking startup co-founded by actor and filmmaker Ben Affleck. The deal marks a significant be…

techcrunch.com

Hugging Face Confirms Security Breach Affecting Internal Datasets and Credentials

AI platform Hugging Face has confirmed a security breach that affected internal datasets and credentials stored on its platform. In response, the company is urging all users to im…

techcrunch.com

Inference Startup Infinity Raises $15M at $100M Valuation Backed by OpenAI and Anthropic Researchers

AI infrastructure startup Infinity has announced a $15 million funding round at a $100 million valuation. The round was led by investors including Touring Capital and Principal VC…

Social Media Updates

We've posted a video of Ruohang Feng of PGSTY's talk Extensions for Everyone

A video recording of Ruohang Feng from PGSTY presenting a talk titled 'Extensions for Everyone' has been posted online. The talk was delivered at PGConf Dev, a PostgreSQL conferen…

We've posted a video of David Wheeler of ClickHouse's talk Building a Foreign Data Wrapper

A video of David Wheeler from ClickHouse presenting a talk titled 'Building a Foreign Data Wrapper' has been posted online. The talk was delivered at PGConf.dev, a PostgreSQL conf…

pg_hardstorage connects to PostgreSQL the same way a streaming replica does.

pg_hardstorage connects to PostgreSQL using the same protocol as a streaming replica. This architectural decision allows it to work seamlessly with managed PostgreSQL services suc…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates