[pilif]

have a look at pg_repack. That'll solve it for you.

> but no amount of vacuuming actually allows us to fully reclaim that space

a full vacuum would. but it would also lock the table for the duration (which is something pg_repack won't do)

[matsemann]

Yup, locking the table is off the table so to speak, heh. Will take a look, thanks.