Re: reindex/vacuum locking/performance? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: reindex/vacuum locking/performance?
Date
Msg-id 20031004152338.GM580@libertyrms.info
Whole thread Raw
In response to Re: reindex/vacuum locking/performance?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Fri, Oct 03, 2003 at 11:49:03PM -0400, Tom Lane wrote:
>
> What if said SELECTs are using the index in question?

That's a good reason to build a new index and, when it's done, drop
the old one.  It still prevents writes, of course.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: reindex/vacuum locking/performance?
Next
From: Bruce Momjian
Date:
Subject: Re: count(*) slow on large tables