@js@mstdn.io @delroth
D'oh. Forgot that autovacuum exists (there used to be something that made manual non-FULL vacuums sensible, but that might have been in some very specific situation~).
> When I did the VACUUM FULL though, that shrank it by more than half.
Oh, that makes me somewhat surprised.
I wonder whether pgsql plans to ever have vacuum full be non-locking (which should be doable if tombstones are a thing).