Re: Curious about dead rows.

[Andrew Sullivan <ajs(at)crankycanuck(dot)ca>]

On Wed, Nov 14, 2007 at 07:12:45AM -0500, Jean-David Beyer wrote:
> 
> I know there have been rollbacks but I do a REINDEX, CLUSTER, and VACUUM
> ANALYZE before starting the inserts in question. Do I need to do a VACUUM
> FULL ANALYZE instead?

I had another idea.  As Alvaro says, CLUSTER will do everything you need. 
But are you sure there are _no other_ transactions open when you do that? 
This could cause problems, and CLUSTER's behaviour with other open
transactions is not, um, friendly prior to the current beta.

A


-- 
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke