Sammlung von Newsfeeds
Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!
Do you like building Postgres extensions? Of course you do! My "Let's Build a Postgres Extension" presentation garnered rave reviews at Postgres Conference 2026 in San Jose and PG Data 2026 in Chicago. But what if you didn't go? Sure the slides are available on both sites, but that's not quite the same, is it?Now that the dust has settled and my long series on Postgres 19 has finally reached its natural conclusion, let's get back to our regularly scheduled shenanigans.
Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!
Do you like building Postgres extensions? Of course you do! My "Let's Build a Postgres Extension" presentation garnered rave reviews at Postgres Conference 2026 in San Jose and PG Data 2026 in Chicago. But what if you didn't go? Sure the slides are available on both sites, but that's not quite the same, is it?Now that the dust has settled and my long series on Postgres 19 has finally reached its natural conclusion, let's get back to our regularly scheduled shenanigans.
Joshua Drake: Parquet and Iceberg: An Overview
Christophe Pettus: All Your GUCs in a Row: io_method and io_workers
Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema
Please note different time and location this month at UpStart Collective at the U.S. Bancorp Tower (a.k.a. Big Pink). Please RSVP on MeetUp. Tuesday September 8, 2026 from 6:30pm to 8:30pm.
Coinciding with devopsdays Portland, OR, Sept 8-10, 2026.
Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6)
In Part 6 of this special Postgres in Production deep dive series, Ryan Booz asks a question that determines how useful pg_stat_statements can be for you at all: do you have a high cardinality workload?
Ryan Booz: Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6)
In Part 6 of this special Postgres in Production deep dive series, Ryan Booz asks a question that determines how useful pg_stat_statements can be for you at all: do you have a high cardinality workload?
Bertrand Drouvot: Welcome to pg_walviz: PostgreSQL WAL segment visualizer
The purpose of this blog post is to introduce pg_walviz, a new tool to visualize PostgreSQL WAL segment files.
pg_waldump is very useful to display a human-readable rendering of the WAL. However, sometimes we also want to see how records are physically stored in a segment: the WAL pages, record fragments, continuation records, alignment padding, block references, full-page images and raw bytes.
Christophe Pettus: All Your GUCs in a Row: io_max_concurrency
Jeremy Schneider: Postgres Checkpoint Followup and Collation Visualization and Codex Luna
My previous article talked about the checkpoint happiness hint: You probably should not change the checkpoint_timeout setting from its default of 5 minutes.
Checkpoint Followup QuestionsA good follow-up question was raised: can an HA replica can save you from downtime if you want to set a large checkpoint_timeout?
Hans-Juergen Schoenig: Introducing the CYBERTEC PG Operator
There is no shortage of PostgreSQL operators for Kubernetes. Projects such as CloudNativePG, the Zalando postgres-operator, Crunchy PGO, and StackGres have all helped shape the ecosystem.
So why did we build another one?Our answer is simple: multi-site PostgreSQL along with other capabilities.
Christophe Pettus: All Your GUCs in a Row: io_combine_limit and io_max_combine_limit
A gofmt-style formatter for SQL
#661 — August 12, 2026
🏖️ We're taking a summer break next week, so the next issue will be on August 26.
__
Your editor, Peter Cooper
Postgres Weekly
Dimitri Fontaine: Introducing sqlfmt: an SQL gofmt-style formatter
Formatting SQL tends to bring some of the same questions again and again: should we uppercase clause keywords? should we put the separating comma at the start of a line to ease refactoring? how to align the SQL clauses with one-another?
Over the years I have grown my own SQL style and didn’t find tooling that would implement it. Also, I’ve been asked here and there if there is a tool that would replicate The Art of PostgreSQL SQL indentation style… and now there is finally a good answer to that question!
Tudor Golubenco: Multi-tenant BYOK encryption in PostgreSQL with pgcrypto
Wellingtone Luvonga: Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO
You have probably read a dozen tutorials on setting up PostgreSQL High Availability (HA). On paper, it looks simple: spin up a primary instance, spin up a standby, and let them replicate.
Christophe Pettus: All Your GUCs in a Row: IntervalStyle
Dmitry Narizhnykh: MySQL vs PostgreSQL Syntax: Translate Queries with AI — Then Verify the Results
Moving a database from MySQL to PostgreSQL is two jobs, not one. Migration tools move the schema and the data. What they don't touch is the long tail behind the database: every query your application, reports, and cron jobs wrote in MySQL's dialect still has to be rewritten for PostgreSQL — one by one. That rewriting is SQL query translation, and it is where migrations quietly lose their weeks.
Floor Drees: EDB is ready for Valencia: Meet the Team at PGConf EU 2026
Umair Shahid: Choosing the Right PostgreSQL Partition Key
Partitioning gets sold as a performance switch. You flip it on a big table, and the slow queries get fast. Most of the time, that is exactly what happens. But there is a version of this where you do all the work, split a huge table into clean partitions, and the slow queries stay exactly as slow as they were. The table is partitioned. Nothing got better.

