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

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

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support