Re: index files still growing - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: index files still growing
Date
Msg-id 3BD891DA.6040702@selectacast.net
Whole thread Raw
In response to Re: index files still growing  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-general

Tom Lane wrote:

> Alvaro Herrera <alvherre@atentus.com> writes:
>

>>Whereas the DROP INDEX/CREATE INDEX method works on-the-fly. You may end
>>up running a seqscan somewhere, but that's not so big a problem, IMHO.
>>
>
> True, that way doesn't lock out concurrent readers of the table while
> the index is rebuilt.


Have the locking issues with reindex been resolved in 7.1.3?




--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com


pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: DBD::Pg
Next
From: "Cornelia Boenigk"
Date:
Subject: Re: ARRAY type and PHP