Re: Persistent dead rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Persistent dead rows
Date
Msg-id 7436.1170945729@sss.pgh.pa.us
Whole thread Raw
In response to Re: Persistent dead rows  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Well, both cluster and vacuum full will require a lock on the table. But
>   they're more or less doing the same thing, so why the one should work
> and the other not I don't know.

CLUSTER isn't MVCC-safe --- it'll drop rows that are committed dead
even if they are potentially still visible to some open transaction.
The OP has *clearly* got an open-transaction problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Persistent dead rows
Next
From: Ged
Date:
Subject: Re: Array OUT columns in a record returned from a function - part deux