index

This tag is associated with 2 posts

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 →

Largest Tables Including Indexes and LOBs

Posted by Jeremy ⋅ December 4, 2013 ⋅ 3 Comments

Just a quick code snippit. I do a lot of data pumps to move schemas between different databases; for example taking a copy of a schema to an internal database to try to reproduce a problem. Some of these schemas have some very large tables. The large tables aren’t always needed to research a particular … Continue reading →