Planet PostgreSQL

Dinesh Kumar: SQL vs PL/pgSQL in PostgreSQL: Plan Caching https://postgr.es/p/9Ac #postgresql

Mats Kindahl: Building a Table Access Method, Part 6: TRUNCATE https://postgr.es/p/9zZ #postgresql

Aleksei Aleinikov: PostgreSQL Indexes: Which Type to Use (10M-Row Benchmark) https://postgr.es/p/9zK #postgresql

Christophe Pettus: All Your GUCs in a Row: restart_after_crash https://postgr.es/p/9Ab #postgresql

Christophe Pettus: All Your GUCs in a Row: reserved_connections https://postgr.es/p/9Aa #postgresql

Devrim GÜNDÜZ: The PostgreSQL RPM repository needs a lot less EPEL now https://postgr.es/p/9A9 #postgresql

Karen Jex: Fostering Inclusivity with the PostgreSQL Europe Diversity Committee https://postgr.es/p/9A8 #postgresql

semab tariq: Your backups are green. That does not mean you can restore. https://postgr.es/p/9A7 #postgresql

Vadim Yatsenko: Speech at PGDay Israel 2026：Durability, Consistency, and Performance https://postgr.es/p/9zW #postgresql

Vadim Yatsenko: DataMax: A Dedicated WAL Log-Store Node for Near-Synchronous Durability https://postgr.es/p/9zY #postgresql

Vadim Yatsenko: Commit Sequence Number (CSN) MVCC: Lock-Free Snapshot Acquisition https://postgr.es/p/9zX #postgresql

Christophe Pettus: All Your GUCs in a Row: remove_temp_files_after_crash https://postgr.es/p/9zU #postgresql

Vadim Yatsenko: PolarFS: Disk-Paxos RW Leases That Keep Shared Storage Out of Split-Brain https://postgr.es/p/9zT #postgresql

Gabriele Bartolini: CNPG Recipe 28 - Generated and rotating PostgreSQL user passwords in CloudNativePG 1.31 https://postgr.es/p/9zS #postgresql

Cornelia Biacsics: Contributions for week 41 & 42 https://postgr.es/p/9zR #postgresql

Christophe Pettus: All Your GUCs in a Row: recursive_worktable_factor https://postgr.es/p/9zP #postgresql

Henrietta Dombrovskaya: pg_acm at PGConf.EU https://postgr.es/p/9zO #postgresql

Ahsan Hadi: Zero Downtime Rolling Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster https://postgr.es/p/9zN #postgresql

Pavel Luzanov: PostgreSQL 19: part 5.4 (SQL, DEV1 and DEV2) of CommitFest 2026-03 https://postgr.es/p/9zM #postgresql

Karen Jex: Tuning Postgres for Analytics - PGConf.EU https://postgr.es/p/9zJ #postgresql

Igor Suhorukov: A knowledge base without a second database: Oxigraph’s SPARQL in PostgreSQL 19 https://postgr.es/p/9zI #postgresql

Christophe Pettus: All Your GUCs in a Row: the recovery_target parameters https://postgr.es/p/9zH #postgresql

Chris van Eijk: Supabase RLS policy examples, tested on PostgreSQL 17 https://postgr.es/p/9zF #postgresql

Chris van Eijk: Supabase RLS policy not working? Ten causes, measured https://postgr.es/p/9zG #postgresql

Devrim GÜNDÜZ: PostGIS is back on Amazon Linux 2023 (with SFCGAL this time) https://postgr.es/p/9zE #postgresql

Muhammad Aqeel: Undo for Postgres, without losing the rest of your day https://postgr.es/p/9zD #postgresql

Umair Shahid: Your app does not need PostgreSQL superuser https://postgr.es/p/9zC #postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 3 https://postgr.es/p/9zA #postgresql

Lætitia AVROT: Region : a lesson in data integrity https://postgr.es/p/9zB #postgresql

Ayoub Kazar: PostgreSQL as a graph database, part 1: SQL/PGQ in PostgreSQL https://postgr.es/p/9zj #postgresql

Ayoub Kazar: PostgreSQL as a graph database, part 0: intro, graphs, graph databases https://postgr.es/p/9z5 #postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_prefetch https://postgr.es/p/9zw #postgresql

Chris van Eijk: Supabase RLS: when (select auth.uid()) helps, measured https://postgr.es/p/9zv #postgresql

Chris van Eijk: hstore vs jsonb performance in PostgreSQL, measured https://postgr.es/p/9zu #postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 2 https://postgr.es/p/9zl #postgresql

Igor Suhorukov: My PostgreSQL is faster than yours and has almost caught up with ClickHouse https://postgr.es/p/9zh #postgresql

Jeremy Schneider: Postgres recovery_prefetch Considered Harmful and Causing Outages https://postgr.es/p/9zf #postgresql

Regina Obe: PostGIS 3.7.0rc3 https://postgr.es/p/9ze #postgresql

Chris van Eijk: idle in transaction in PostgreSQL: what it holds https://postgr.es/p/9zd #postgresql

Chris van Eijk: could not serialize access due to concurrent update https://postgr.es/p/9zc #postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_init_sync_method https://postgr.es/p/9zb #postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 1 https://postgr.es/p/9za #postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_min_apply_delay https://postgr.es/p/9z9 #postgresql

Floor Drees: From a conversation to the CNPG Headlamp Plugin https://postgr.es/p/9z8 #postgresql

Pavel Luzanov: PostgreSQL 19: part 5.3 (DBA3 and DBS) of CommitFest 2026-03 https://postgr.es/p/9z7 #postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_end_command https://postgr.es/p/9z6 #postgresql

Chris van Eijk: unrecognized configuration parameter in PostgreSQL https://postgr.es/p/9z4 #postgresql

Chris van Eijk: remaining connection slots are reserved in PostgreSQL https://postgr.es/p/9z3 #postgresql

Devrim GÜNDÜZ: Every package in the PostgreSQL RPM repositories now has a page https://postgr.es/p/9z2 #postgresql

Tom Kincaid: PostgreSQL 19: What Changed, What Matters, and What to Test Now https://postgr.es/p/9z1 #postgresql