Tom Lane wrote:
The CLUSTER may be affecting things in some other way, like by squeezing out
dead tuples causing a
reduction in the total table and index sizes.
I didn't mention I was the only user with transactions open on the
system during this. Would cluster eliminate more rows then
We are trying to ascertain if we are up against the limits of what
postgres can accomplish without having the tables clustered. We would
prefer not to have to cluster our tables because according to the
documentation this is a one time operation and not maintained. Is there
any other performa