Re: Concurrently option for reindexdb

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Concurrently option for reindexdb
Дата
Msg-id 5405423D.1080403@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Concurrently option for reindexdb  (Sawada Masahiko <sawada.mshk@gmail.com>)
Ответы Re: Concurrently option for reindexdb  (Fujii Masao <masao.fujii@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: PL/pgSQL 2
Следующее
От: Shigeru Hanada
Дата:
Сообщение: Re: Optimization for updating foreign tables in Postgres FDW