index

This tag is associated with 3 posts

Agents Gone Awry on Postgres SBOMs: Start Over

Posted by Jeremy ⋅ September 15, 2026 ⋅ Leave a comment

If you were wondering, it’s the SBOM thing that I mentioned the other day. Postgres Extensions in containers with full inventory, provenance and attestation. I’ve been using plenty of AI Agents to put this together. This blog is a little scattered (apologies) but as they say, I didn’t have time to write a short letter. … 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 →

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 →