Re: Support for REINDEX CONCURRENTLY

Michael Paquier <michael.paquier@gmail.com>

From: Michael Paquier <michael.paquier@gmail.com>

To: Andres Freund <andres@2ndquadrant.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Simon Riggs <simon@2ndquadrant.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2013-01-16T06:33:15Z

Lists: pgsql-hackers

Attachments

20130116_reindex_concurrently_v7.patch (application/octet-stream) patch v7

Hi,

Please find attached v7 of this patch, adding support for REINDEX DATABASE
CONCURRENTLY.
When using REINDEX DATABASE with CONCURRENTLY, non-system tables are
reindexed concurrently and system tables are reindexed in the normal way,
ie non-concurrently.

Thanks,
-- 
Michael Paquier
http://michael.otacoo.com

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Background worker processes
- da07a1e85651 9.3.0 cited
Fix assorted bugs in CREATE/DROP INDEX CONCURRENTLY.
- 3c84046490be 9.3.0 cited
Work around unportable behavior of malloc(0) and realloc(NULL, 0).
- 09ac603c36d1 9.3.0 cited
Properly set relpersistence for fake relcache entries.
- beb850e1d873 9.3.0 cited