Re: reindex/vacuum locking/performance?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: reindex/vacuum locking/performance?
Date: 2003-10-04 15:23:38
Message-ID: 20031004152338.GM580@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-10-04 15:56:40 Re: count(*) slow on large tables
Previous Message Andrew Sullivan 2003-10-04 15:22:41 Re: reindex/vacuum locking/performance?