Follow

@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).

Sign in to participate in the conversation
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.