This blog is based on a real production case in which users experienced a serious delay in logical replication. Let me try to explain how to approach...

   We leave the archive arc behind and enter the first of several backward-compatibility GUCs. array nulls controls whether the array input parser...

   PostgreSQL 18 shipped asynchronous I O. PostgreSQL 19, currently in feature freeze and headed for a September release, makes it tolerable to operate....

   Time zones are an unfortunately complex subject when dealing with PostgreSQL. You may be running your local time zone on your on-premises server or...

   For about fifteen years, the standard answer to this table is bloated, what do I actually do about it has been one of the out-of-tree options: pg...

   Another great evening for the PostgresEDI community First off, a massive thank you to everyone who came out to our April meetup. The discussions were...

   The archiver only runs when a WAL segment is complete. On a busy database that happens constantly; on a quiet one it might not happen for hours or...

   Hello everyone, here comes a series of my annual posts about the Chicago Postgres Conference, and what I am most excited about. And I want to start...

   PgBackRest Is Dead Yesterday the maintainer of PgBackRest, David Steele, published the NOTICE OF OBSOLESCENCE. For further information please read...

   First in a series of dispassionate surveys of the major managed-Postgres offerings. This post is about Amazon RDS for PostgreSQL what AWS calls...

   In the previous article we watched every UPDATE leave dead tuple behind. The same copy-on-write behaviour shows up from the operational angle in...

   PostgreSQL 19 ships with parallel autovacuum. The new GUC autovacuum max parallel workers caps the cluster-wide pool, and the per-table storage...

   Stephen O’Grady’s State of Open Source Licensing in 2026 at RedMonk is essential reading. The headline finding that the long shift from copyleft to...

   pgBackRest is an open source backup and restore tool for PostgreSQL. It’s fair to say it’s one of the most popular options, widely used across the...

   PGConf Germany 2026 took place on April 21 and April 22 2026 in Essen, Germany Organized by: Andreas Kretschmer Andreas Scherbaum Cornelia Biacsics...

   Yesterday, David Steele announced the end of life of pgBackRest a PostgreSQL backup tool he maintained for thirteen years. The reasons are structural...

   Laurenz Albe 2026 Over the years of training, consulting and supporting PostgreSQL users, I have come up with a number of queries to monitor...

   archive mode is the master switch for WAL archiving. With the last three posts under our belts archive cleanup command, archive command, archive...

   Yesterday David Steele announced that he is stepping away from pgBackRest. After thirteen years, the most widely-deployed dedicated backup tool in...

   For thirty years, the answer to how do I get the DDL for this object? in PostgreSQL has been: shell out to pg dump -s and grep. Every tool that has...

   For about fifteen years the answer to can I turn on data checksums without an initdb? has been not really. pg checksums showed up in PostgreSQL 12...

   Introduction When people first start reading PostgreSQL execution plans, they quickly learn a few common scan types: Seq Scan, Index Scan, Index Only...

   Before getting into this one, an errata against the previous post. I said backup tools can register as an archive library and bypass archive command...

   I have been recommending pgBackRest as the best backup tool for PostgreSQL for years. I even wrote a blog post about it. My students at Université...

   Last post’s deferred party has arrived. archive command is how WAL segments leave the primary and travel somewhere durable the substrate on top of...

   Alphabetical order delivers our first casualty. archive cleanup command is a standby-server knob that exists entirely to tidy up after archive...

   The previous post on the Linux 7.0 pgbench regression ended with the same instruction every other Postgres performance post ends with: set huge pages...

   Last year’s acquisitions have now shipped products, and for the first time it is possible to compare the Snowflake and Databricks Postgres-in-the...

   There’s a persistent belief in the database world that vertical scaling solves all problems. Need more throughput? Add CPUs. Running out of cache?...

   Do family meetups always devolve into SQL?