Hubert 'depesz' Lubaczewski: When to use VACUUM FULL
Well, the short answer is: NEVER. But given how often I see people ask about it, I'll try to expand my answer a bit… Every now and then on IRC, Slack, Discord , or Reddit people ask questions about VACUUM FULL. And they do. They tend to put vacuum full calls in crons, or just … Continue reading "When to use VACUUM FULL"
永远不要使用VACUUM FULL，它会锁定整个表，使得其他操作无法进行。正确的做法是使用pg_repack，它可以重写表而不会锁定其他操作，而且可以并行重建索引，更快。可以在数据库服务器或同一网络中的主机上安装和使用pg_repack，AWS和GCP也支持它。
