PostgreSQL

This category contains 43 posts

PostgresConf 2019 Training Days

Posted by Jeremy ⋅ March 19, 2019 ⋅ 1 Comment

It feels like PostgresConf in New York is in full swing, even though the main tracks haven’t even started yet! (Oh, and by the way, as of this morning I heard there are still day-passes available for those who haven’t yet registered for the conference… and then you can come hear a great session about … Continue reading →

Column And Table Redefinition With Minimal Locking

Posted by Jeremy ⋅ November 8, 2018 ⋅ 1 Comment

TLDR: Note to future self… (1) Read this before you modify a table on a live PostgreSQL database. If you do it wrong then your app might totally hang. There is a right way to do it which avoids that. (2) Especially remember the lock_timeout step. Many blog posts around the ‘net are missing this … Continue reading →

This Week in PostgreSQL – May 31

Posted by Jeremy ⋅ June 4, 2018

Since last October I’ve been periodically writing up summaries of interesting content I see on the internet related to PostgreSQL (generally blog posts). My original motivation was just to learn more about PostgreSQL – but I’ve started sharing them with a few colleagues and received positive feedback. Thought I’d try posting one of these digests … Continue reading →