Re: Concurrently option for reindexdb - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Concurrently option for reindexdb
Date
Msg-id 5405423D.1080403@2ndquadrant.com
Whole thread Raw
In response to Re: Concurrently option for reindexdb  (Sawada Masahiko <sawada.mshk@gmail.com>)
Responses Re: Concurrently option for reindexdb  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
On 09/02/2014 11:10 AM, Sawada Masahiko wrote:
> The currently patch dose not hack catalog, just create new index
> concurrently and
> swap them.
> So, It is supporting only UNIQUE index, I think.

UNIQUE indexes, but not a UNIQUE constraint backed by a UNIQUE index, or
a PRIMARY KEY constraint backed by a UNIQUE index.

> This patch contains some limitation.
> Also I'm thinking to implement to handle these cases.

My understanding from the prior discussion is that any satisfactory
solution to those problems would also make it possible to support
REINDEX CONCURRENTLY natively.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PL/pgSQL 2
Next
From: Shigeru Hanada
Date:
Subject: Re: Optimization for updating foreign tables in Postgres FDW