Re: reindex/vacuum locking/performance?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Christopher Browne <cbbrowne(at)libertyrms(dot)info>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: reindex/vacuum locking/performance?
Date: 2003-10-03 23:48:07
Message-ID: 1065224887.387.45.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2003-10-03 at 17:34, Christopher Browne wrote:
> Not surprising either. While the reindex takes place, updates to that
> table have to be deferred.

Right, but that's no reason not to let SELECTs proceed, for example.
(Whether that would actually be *useful* is another question...)

-Neil

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2003-10-04 00:14:50 Re: reindex/vacuum locking/performance?
Previous Message Matt Clark 2003-10-03 23:44:33 Re: reindex/vacuum locking/performance?