In response to Alvaro Herrera <alvherre@commandprompt.com>:
> 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?
> >
> > 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.