Re: [PERFORM] Performance hit on large row counts

2005-12-26 Thread David Scott
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

[PERFORM] Performance hit on large row counts

2005-12-26 Thread David Scott
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