Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 - Mailing 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