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.)
