Postgres Weekly 🐘

Postgres / PostgreSQL news from the Postgres Weekly email newsletter.

[Postgres Weekly 🐘 @PostgresWeekly]

📬 Join over 14,000 subscribers and get a free, weekly digest of #PostgreSQL news in your inbox: https://t.co/WgqhVMgWff

[Postgres Weekly 🐘 @PostgresWeekly]

`\gexec` in `psql`: A Postgres Power User Practice? https://t.co/xm6rJqVACn

[Postgres Weekly 🐘 @PostgresWeekly]

PostgreSQL 14 Internals: The Book - https://t.co/73psYnQ1JD

[Postgres Weekly 🐘 @PostgresWeekly]

Working with `DISTINCT` in Postgres 15: https://t.co/2pt31eQcT9

[Postgres Weekly 🐘 @PostgresWeekly]

Some Notes on GitLab’s Postgres Schema Design: https://t.co/lBpjLtonGM

[Postgres Weekly 🐘 @PostgresWeekly]

Data to Go: Postgres Logical Replication - https://t.co/xdpErX9Un7

[Postgres Weekly 🐘 @PostgresWeekly]

Enabling and Enforcing SSL/TLS for Postgres Connections: https://t.co/ovmjmHQHQz

[Postgres Weekly 🐘 @PostgresWeekly]

Initial Findings from the State of PostgreSQL 2022 Survey: https://t.co/xlO2Oydkhb

[Postgres Weekly 🐘 @PostgresWeekly]

Column Order in Postgres Does Matter: https://t.co/zNtysnG13r

[Postgres Weekly 🐘 @PostgresWeekly]

How Postgres 15 Improves `UNIQUE` and `NULL`: https://t.co/GFLekWDk8Z

[Postgres Weekly 🐘 @PostgresWeekly]

Transaction Anomalies with `SELECT FOR UPDATE`: https://t.co/ejettox0g4

[Postgres Weekly 🐘 @PostgresWeekly]

How to Log Selects From a Specific Table? https://t.co/ACFDqObfjp (A practical introduction to using PGAudit. It's nice to have access to this sort of feature.)

[Postgres Weekly 🐘 @PostgresWeekly]

Understanding `pg_stat_activity`: https://t.co/iUElgBn6aZ

[Postgres Weekly 🐘 @PostgresWeekly]

PostgreSQL 15 Beta 2 Released: https://t.co/oAJIumJ98j

[Postgres Weekly 🐘 @PostgresWeekly]

Google Cloud Spanner's Postgres Interface Goes GA: https://t.co/eaPkbaOaYE

[Postgres Weekly 🐘 @PostgresWeekly]

Using Cloudflare Tunnel and Access with Postgres: https://t.co/4zEkLsW0qe

[Postgres Weekly 🐘 @PostgresWeekly]

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

[Postgres Weekly 🐘 @PostgresWeekly]

Postgres Upgrades Are Hard: https://t.co/gyY3wEJNVp

[Postgres Weekly 🐘 @PostgresWeekly]

Postgres Indexes, Selectivity, and Statistics: https://t.co/E3Ix18HItM (A look under the covers at some ways to tweak things when Postgres's query planning isn't quite up to par.)

[Ryan Booz @ryanbooz]

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! https://t.co/rMx8XDVO8r

[Postgres Weekly 🐘 @PostgresWeekly]

Debugging Deadlocks in Postgres: https://t.co/uisU0Ooea4