#​442 — February 16, 2022

Web Version

Postgres Weekly

⭐️  A Hairy Postgres Incident — A team upgraded to Postgres 11 in one of their regions and their app began experiencing “problems.” The author came to the rescue in a rather significant way. This is a fantastic tale of problem solving and an example of how complex seemingly simple issues can get.

Jeremy Schneider

PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released — Updates for all maintained versions of Postgres to fix over 55 bugs reported over the past several months, covering areas from index corruption and crashes to memory leaks and the query planner.

PostgreSQL Global Development Group

CYBERTEC MIGRATOR - The Easiest Way from Oracle to Postgres — If your company is locked into an expensive Oracle license, you can save costs by migrating to PostgreSQL. You may wonder, “How can I migrate our databases with the most security and the least downtime possible?” CYBERTEC MIGRATOR is the answer.

CYBERTEC sponsor

Postgres Constraints for Newbies — Some quick explanations and examples of various types of constraint you can put in place in Postgres, including those on foreign keys, uniqueness, null-ness, exclusion, and check constraints. There’s also a handy (if large) query for finding out what constraints already exist in your database.

Elizabeth Christensen

TOAST Compression and toast_tuple_target — If you have rows in a table that store large amounts of data, Postgres will lean on a mechanism called TOAST to store extra data in a separate place and refer to that from the original table. One benefit of this is that Postgres can compress this data, and you can customize the threshold for this occurring.

Adrien Nayrat

Safer Application Users in Postgres — A guide to changing app user permissions so they can’t delete your production database, say.

Mike Palmiotto

How Much Disk Space You Can Save Using Smaller Integers? — Picking over a few bytes used to represent an integer feels too detailed to me, but at scale maybe it could make a difference? Turns out, no, not really, and the amount of planning and ordering needed to make it work is disproportionate to any gains.

Hubert depesz Lubaczewski

Studio 3T Manages Your Data, While You Wrestle Your App into Shape

Studio 3T sponsor

How to Fix a Sequence When It Goes Out of Sync in Postgres
Antonello Zanini

In brief: