Re: Is there a work around for partition key needed for constraint

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Is there a work around for partition key needed for constraint
Дата
Msg-id 20181025135931.jbo5gnfyd5aliwhu@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Is there a work around for partition key needed for constraint  (Keith Fiske <keith.fiske@crunchydata.com>)
Список pgsql-admin
On 2018-Oct-24, Keith Fiske wrote:

> The real solution will have to wait on a global index in a future version.

Actually, there might be another way to implement it, namely to use the
speculative tokens on every affected local btree, then do the actual
insert in the correct index, then remove the unused speculative tokens
from all the other indexes.  Then you don't need a global tree at all.

I'm not planning to work on this, and haven't heard that anyone is.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-admin по дате отправления:

Предыдущее
От: Mihalidesová Jana
Дата:
Сообщение: Using pg_basebackup via pgpool fail
Следующее
От: "Ghiurea, Isabella"
Дата:
Сообщение: upgrade slave in streaming replication from PG 10.4 to 10.5.1