Martijn van Oosterhout wrote: ...
AIUI, people know VACUUM FULL sucks and that in the cases where it really helps CLUSTER is faster anyway and doesn't have the index problems. The TODO list reference several discussions on the topic.Or, failing that, what's the reason to not issue a REINDEX CONCURRENTLY automatically after a VACUUM FULL (or something to that effect)?Or how about not doing VACUUM FULL at all. It's not a command that should be run regularly in most situations.
Which makes me think if the solution would be to just run CLUSTER under the hood when VACUUM FULL is requested. Would that introduce any other problems? Cheers Tino
smime.p7s
Description: S/MIME Cryptographic Signature
