atlas news
  Planet PostgreSQL
16  september     15h42
Joshua Drake: PostgreSQL 19: Sept 08 - Sept 16, 2026
   Version 19: 71 commits on REL 19 STABLE. Version 20: 46 commits on master. Reverted out of 19: 74 commits, in 6 reverts. Six features tracked, 2...
    07h00
Florent Jardin: Inspecting a catalog with pg migrate
   Over the past few years, I have been working on assessing the strengths andweaknesses of PostgreSQL migration tools. Several articles published by...
    01h00
Christophe Pettus: All Your GUCs in a Row: max locks per transaction
   max locks per transaction isn’t about transactions or limits it sizes the cluster-wide lock table, and its misleading name has confused PostgreSQL...
15  september     21h40
Jeremy Schneider: Agents Gone Awry on Postgres SBOMs: Start Over
   If you were wondering, it’s the SBOM thing that I mentioned the other day.Postgres Extensions in containers with full inventory, provenance and...
    16h27
Dimitri Fontaine: Plan Advice in PostgreSQL 19
   There is a conversation that happens in every PostgreSQL shop eventually. Aquery that has been fine for a year gets slow overnight. Nothing...
    16h00
Christophe Pettus: 19th Nervous Breakdown
   PostgreSQL 19’s release crumbled under its own ambition: eight major features landed in five weeks before freeze, three committers pulled their work,...
    15h02
Jimmy Angelakos: Send us a contribution straight from the site
   Until now, the only way to tell us about a contribution worth listing wasemail. There is now aform on the site instead.You do not need an account,...
    12h37
Jimmy Angelakos: PostgreSQL Commitfest Metrics: PGConf.dev 2026 Part One
   Obviously I would have liked to post this closer to the event, but life got in the way. The talk was in May and the recording has been up for a while...
    10h00
Tomas Vondra: Postgres development activity
   Every now and then I need a break from writing code. In those cases Ilike looking at data about a subject I’m interested in - looking fortrends,...
    01h00
Christophe Pettus: All Your GUCs in a Row: max index keys
   PostgreSQL’s max index keys has counted more than keys since INCLUDE columns arrived in version 11, but stays locked at 32 due to on-disk tuple...
14  september     08h29
Cornelia Biacsics: Contributions for week 36
   On 8 September 2026, PGDay UK 2026 was held in London. Organized by: Chris EllisDave PageDevrim GunduzProgram Committee: Alastair Turner (chair, non...
    08h00
Richard Yen: Looking Forward to PG Summit 2026
   On October 1, I’ll be speaking at PG Summit 2026 about benchmarking hardware with Postgres. I’m looking forward to sharing some tips and learnings...
    01h00
Christophe Pettus: All Your GUCs in a Row: max identifier length
   max identifier length reports a number, 63, and the number is the least interesting thing about it. Every relational database caps the length of a...
13  september     01h00
Christophe Pettus: All Your GUCs in a Row: max function args
   PostgreSQL won’t let you pass more than 100 arguments to a function, and changing it requires rebuilding every extension on your machine.
12  september     04h30
Jeremy Schneider: Misc Learnings: SBOMs, Provenance and Attestations
   In the past couple weeks, I’ve learned more about renovate, SBOMs, provenance and attestations than I ever wanted to know. (But if I’m...
    01h00
Christophe Pettus: All Your GUCs in a Row: max files per process
   PostgreSQL’s max files per process isn’t a hard limit it’s a descriptor pool that quietly recycles old files when full.
11  september     11h18
Shaun Thomas: PG Phriday: The Folder That Ate the Publisher
   Logical replication has been part of Postgres since version 10, and the syntax page that governs it is almost comically brief. wants a name, a...
    08h15
Radim Marek: The unbearable lightness of one more index
   Being the database guy comes with a lot of questions, and over the last eight months those questions changed. The repetitive ones disappeared, nobody...
    01h00
Christophe Pettus: All Your GUCs in a Row: max connections
   max connections is a memory budget and a circuit breaker wearing a capacity costume. It does not decide how many queries your server can run at once;...
    00h00
Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it.
   A prepared statement ran in 274 ms for five executions and 2,319 ms from the sixth, on the same connection in the same minute. One EXPLAIN ANALYZE is...
    00h00
Mikhail Shytsko: Your Agent Can Turn Off Its Own Kill Switch
   A new agent needs a database login, so the role it logs in as gets the treatment every runbook recommends. Two ALTER ROLE lines go in, one capping...
10  september     17h33
Andrei Lepikhov: Optimising PostgreSQL Aggregates: What Can an Extension Do?
   Aggregates in PostgreSQL aren’t particularly efficient, computationally speaking. It shows most in a scenario where partial aggregation doesn’t help...
    11h49
Umair Shahid: How to De-Risk a Mission-Critical PostgreSQL Migration
   Key takeawaysSpeed is the wrong finish line. If moving the date by a week buys you a clean cutover, move it.Define success in numbers first: zero...
    01h00
Christophe Pettus: All Your GUCs in a Row: max active replication origins
   max active replication origins is a ten-year-old XXX comment that finally got paid off. It arrived in PostgreSQL 18, and it exists because the thing...
    00h00
Ruohang Feng: Chinese PostgreSQL Docs Are Live: All 11 Major Versions
   pgsql.cc is live, with Chinese documentation for all 11 PostgreSQL major versions from 10 through 20, a redesigned mirror of the official website,...
09  september     19h27
Dave Stokes: Structured Query Language 101 at Texas Linuxfest
   nbsp;Structured Query Language 101 -15:00-16:20Nov. 6, 2026 15:00 - 6:20I will be teaching the basics of SQL at the 2026 Texas Linuxfest. The session...
    17h40
Elizabeth Garrett Christensen: 30 Years of Postgres Architecture: Tom Lane Interview
   nbsp;Elizabeth: I know a little bit of your history prior to joining the Postgres project. I think you did work on JPEG the image specification. The...
    16h46
Jimmy Angelakos: 100,000 Lines of C Later: pgSafe at PGDay UK 2026
   Yesterday I had the pleasure of speaking at PGDay UK 2026 in London, at the Cavendish Conference Centre. The talk was called 100,000 Lines of C...
    16h08
Viacheslav Sarzhan: Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging
   Percona Operator for PostgreSQL 3.1.0 takes on three things that decide whether a PostgreSQL platform passes review: is the data encrypted at rest,...
    01h00
Christophe Pettus: All Your GUCs in a Row: maintenance work mem
   Unlock faster index builds and vacuum operations by understanding maintenance work mem: PostgreSQL’s one-allocation memory budget that actually...
1789585877