Re: index files still growing

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index files still growing
Date: 2001-10-25 22:27:38
Message-ID: 3BD891DA.6040702@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> Alvaro Herrera <alvherre(at)atentus(dot)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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cornelia Boenigk 2001-10-25 23:32:24 Re: ARRAY type and PHP
Previous Message Roderick A. Anderson 2001-10-25 21:49:15 Re: DBD::Pg