Re: Vacuum (table performance) - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum (table performance)
Date
Msg-id 19228.1056583654@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum (table performance)  ("Claudio Lapidus" <clapidus@hotmail.com>)
List pgsql-general
"Claudio Lapidus" <clapidus@hotmail.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Does a REINDEX of the table fix it?

> Hmm, I'm looking at the documentation and it says that REINDEX acquires an
> exclusive lock on the table. Does this mean that during the reindex
> operation the table is unavailable for read/write by other processes?

Yes.  At the moment, I am just asking this as a means of helping to
pinpoint where the problem is.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Vacuum (table performance)
Next
From: "Claudio Lapidus"
Date:
Subject: Re: Vacuum (table performance)