Working with the Postgres development community is such a rewarding experience.

In January 2024, Pavel Stehule asked in the hackers mailing list: why is there no VACUUM FULL CONCURRENTLY?

mailing list why

I happen to know that Pavel works as a consultant with some very large, very high velocity databases. He knows many interesting stories, and he doesn’t ask questions just because. If he asks why don’t we have VACUUM FULL CONCURRENTLY, you can bet that there is an interesting production-server story behind that.

Why VACUUM FULL wasn't enough

Now you, gentle reader, might be wondering what the deal is with this VA