Re: Curious about dead rows.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Curious about dead rows.
Date: 2007-11-14 15:22:49
Message-ID: 20071114152249.GA16041@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-David Beyer 2007-11-14 16:53:17 Re: Curious about dead rows.
Previous Message Jean-David Beyer 2007-11-14 14:58:33 Re: Curious about dead rows.