Bill Moran wrote: > In response to Josh Berkus <[EMAIL PROTECTED]>: > > > -- 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
