In response to Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>: > Bill Moran wrote: > > In response to Josh Berkus <josh@xxxxxxxxxxxxxx>: > > > > > -- 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.
