When you need to change a table, and we’re talking big changes like changing a column type, adding a constraint, or creating an index, you have to be careful if the database is busy. Viktoriia Romanchenko lists common changes with the fastest workarounds, and Robins Tharakan lists what kinds of queries cause the table to be rewritten.

AWS RDS Performance Insights now gives tips that are supposedly based on your workloads. To see them, go into the AWS portal, Amazon RDS, and then it’s “Recommendations” in the side nav bar. I hope other people are getting better recommendations than me, though: so far, it’s only told me to add a reader instance to a dev cluster, which would just… cost me more.

AWS Aurora Postgres still doesn’t have Backtracking, something I’ve stared at lustily since it was announced back in 2018. The quick rewind feature is only in Aurora MySQL.

9 ways to shoot yourself in the foot with PostgreSQL. There are always gonna be debates on these kinds of rules, but #2, putting all your business logic in functions & procedures, might be the most contentious.

When Did Postgres Become Cool? This list avoids an elephant in the room: when Oracle bought MySQL.