~postgresweekly | Issue 549 - Making a first contribution to Postgres (9)

R.I.P. Postgres Maintainer Simon Riggs — It’s with much sadness we share the news that Postgres contributor (and author of several Postgres books) Simon Riggs has died in a crash at Duxford airfield in the UK. The core team shared its own tribute noting his contributions, including point-in-time recovery, hot standby, and synchronous replication. His final talk was at PGConf EU in December about...

Contributing to Postgres 101: A Beginner's Experience — I’ve recently seen some people lament how difficult it can be to figure out how to contribute to certain open source projects, so if that’s you with Postgres, Elizabeth’s experiences in submitting a patch and getting it approved will be super useful.

Optimize Database Performance with Crunchy Bridge — Boost your Postgres performance with Crunchy Bridge! YNAB experienced 30% more IOPS and a 10% cost reduction. Scale seamlessly, stay on vanilla Postgres, and optimize spend. Read more in the YNAB case study.

Taming WAL File Growth — A quick introduction to the Write Ahead Log subsystem in Postgres, including a look at the key things to monitor for detecting WAL file build up.

journald and Syslog Logging in Postgres — Using journald and syslog logging with Postgres isn’t a new idea, but Laurenz thinks more people should be giving it a go and so has put together this basic tutorial: “I switched my PostgreSQL instance to syslog logging, and I don’t think I will switch back.”

Why Has Figma Reinveted the Wheel with Postgres? — A closer look at Figma’s custom sharding solution with motivations and future predictions.

Building a Managed Postgres Service in Rust: Part 1 — A little peek behind the scenes at Tembo.