Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2

In response to Alvaro Herrera <alvherre(at)commandprompt(dot)com>:

> Bill Moran wrote:
> > In response to Josh Berkus <josh(at)postgresql(dot)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?
> >
> > If so, the 8.2 docs are a bit out of date:
> > http://www.postgresql.org/docs/8.2/static/sql-reindex.html
>
> No, it means you can do CREATE INDEX CONCURRENTLY.
>
> http://www.postgresql.org/docs/8.2/static/sql-createindex.html

Ahh ... and the text there specifically states that REINDEX does
_not_ work concurrently.

Thanks.

--
Bill Moran
Collaborative Fusion Inc.