On Thu, Apr 26, 2007 at 12:13:13AM +0200, Listmail wrote:
> VACUUM FULL is slow because it plays with the indexes...
> CLUSTER is slow because it has to order the rows...
And:
VACUUM FULL has to seek/read/write all over the disk to get it's job
done.
CLUSTER can scan through the table linearly a few times and write out
the result.
Now it's true that sorting large files involves overflowing to disk,
but that path has been pretty well optimised.
As the ratio between read time and seek time gets worse, I expect
CLUSTER to keep pulling ahead.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.