pgsql: Add: > > * Add REINDEX CONCURRENTLY, like CREATE INDEX

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add: > > * Add REINDEX CONCURRENTLY, like CREATE INDEX
Date: 2007-01-31 03:17:49
Message-ID: 20070131031749.2B9729FB3EB@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2057&r2=1.2058)
pgsql/doc/src/FAQ:
TODO.html (r1.558 -> r1.559)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.558&r2=1.559)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2007-01-31 04:12:01 pgsql: Add missing colon.
Previous Message Bruce Momjian 2007-01-31 03:07:36 pgsql: Update for VACUUM FULL: < reindex rather than update the