Smart Postgres News and Techniques 2024 Vol 13

Struggling with vacuuming? Got a table where you’re constantly deleting the oldest data, and vacuuming can’t keep up? It’s time to investigate partitioning with Lee Asher.


Want a production PostgreSQL DBA job? Kubernetes is on its way to being the new standard HA technique, and your job skills will be more valuable if you have a T-shaped skill profile with a specialization in Kubernetes. (I’m emphasizing this only for production DBAs here: prod and dev DBAs are different and have different job duties.)


Hate mailing lists? I’m right there with you: it’s hard to get automated summaries of important stuff when you’ve been away for a couple/few days. Tomas Vondra ponders what’s next for managing Postgres development.


Want to brainstorm on database design? Postgres.new (HN discussion) lets you chat with OpenAI about the database you want to create, and see it created in real time. (It’s an early preview and buggy as hell, doesn’t work at all for me on Safari on Mac, but interesting concept.)

Previous Post
Announcing Early Access to My Performance Training
Next Post
The Fundamentals of Select: An Introduction to Postgres Performance

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed