Postgres Weekly 🐘

📬 Join over 14,000 subscribers and get a free, weekly digest of #PostgreSQL news in your inbox: postgresweekly.com

`\gexec` in `psql`: A Postgres Power User Practice? cybertec-postgresql.com/en/gexec-psql-…

PostgreSQL 14 Internals: The Book - postgrespro.com/community/book…

Working with `DISTINCT` in Postgres 15: percona.com/blog/introduci…

Some Notes on GitLab’s Postgres Schema Design: shekhargulati.com/2022/07/08/my-…

Data to Go: Postgres Logical Replication - crunchydata.com/blog/data-to-g…

Enabling and Enforcing SSL/TLS for Postgres Connections: percona.com/blog/enabling-…

Initial Findings from the State of PostgreSQL 2022 Survey: timescale.com/blog/state-of-…

Column Order in Postgres Does Matter: cybertec-postgresql.com/en/column-orde…

How Postgres 15 Improves `UNIQUE` and `NULL`: blog.rustprooflabs.com/2022/07/postgr…

Transaction Anomalies with `SELECT FOR UPDATE`: cybertec-postgresql.com/en/transaction…

How to Log Selects From a Specific Table? depesz.com/2022/07/04/how… (A practical introduction to using PGAudit. It's nice to have access to this sort of feature.)

Understanding `pg_stat_activity`: depesz.com/2022/07/05/und…

PostgreSQL 15 Beta 2 Released: postgresql.org/about/news/pos…

Google Cloud Spanner's Postgres Interface Goes GA: cloud.google.com/blog/products/…

Using Cloudflare Tunnel and Access with Postgres: blog.cloudflare.com/cloudflare-tun…

pgenv 1.3: Postgres Binary Manger - github.com/theory/pgenv (Aims to make it simple to build and run different releases of Postgres, particularly for switching between them to test, etc.)

Postgres Upgrades Are Hard: andreas.scherbaum.la/blog/archives/…

Postgres Indexes, Selectivity, and Statistics: crunchydata.com/blog/indexes-s… (A look under the covers at some ways to tweak things when Postgres's query planning isn't quite up to par.)

The State of PostgreSQL 2022 survey will close in two days! Here are a few thoughts on interesting things we're learning and how you can add your voice, too! And, ALL anonymized data will be made available to everyone in a few weeks! softwareandbooz.com/the-2022-state…

Debugging Deadlocks in Postgres: cybertec-postgresql.com/en/debugging-d…