This is a discussion on pgsql: Add: > > * Add REINDEX CONCURRENTLY, like CREATE INDEX within the pgsql Committers forums, part of the PostgreSQL category; --> Log Message: ----------- Add: > > * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY > > This is difficult ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Log Message: ----------- Add: > > * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY > > This is difficult because you must upgrade to an exclusive table lock > to replace the existing index file. CREATE INDEX CONCURRENTLY does not > have this complication. This would allow index compaction without > downtime. Modified Files: -------------- pgsql/doc: TODO (r1.2057 -> r1.2058) (http://developer.postgresql.org/cvsw...2057&r2=1.2058) pgsql/doc/src/FAQ: TODO.html (r1.558 -> r1.559) (http://developer.postgresql.org/cvsw...1.558&r2=1.559) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |