| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Concurrently option for reindexdb |
| Date: | 2014-09-02 04:06:21 |
| Message-ID: | 5405423D.1080403@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shigeru Hanada | 2014-09-02 04:10:36 | Re: Optimization for updating foreign tables in Postgres FDW |
| Previous Message | Craig Ringer | 2014-09-02 04:04:35 | Re: PL/pgSQL 2 |