Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2
Date
Msg-id 1165353222.31648.54.camel@localhost.localdomain
Whole thread Raw
In response to Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available)  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
On Tue, 2006-12-05 at 16:06 -0500, Bill Moran wrote:
> In response to Josh Berkus <josh@postgresql.org>:
>
> > -- Online index builds
>
> I'm particularly curious about this feature.  Does this mean that
> PostgreSQL 8.2 can perform a REINDEX without blocking the relevant
> table from writes?

I don't know about reindex, but it is possible to drop and create the
index.

Sincerely,

Joshua D. Drake


>
> If so, the 8.2 docs are a bit out of date:
> http://www.postgresql.org/docs/8.2/static/sql-reindex.html
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: HELP: Urgent, Vacuum problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available)