Re: Proposal: partition pruning by secondary attributes

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: Proposal: partition pruning by secondary attributes
Дата
Msg-id CAFjFpRdPzR=jOqJ6J2dLthyqeytQC_vreStzobhXkBGrUZam5Q@mail.gmail.com
обсуждение исходный текст
Ответ на Proposal: partition pruning by secondary attributes  (Ildar Musin <i.musin@postgrespro.ru>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, Feb 8, 2018 at 4:51 PM, Ildar Musin <i.musin@postgrespro.ru> wrote:
>
> The idea is to store min and max values of secondary attributes (like
> 'id' in the example above) for each partition somewhere in catalog and
> use it for partition pruning along with partitioning key.

Every insertion and update of secondary attribute will touch catalog
and update if required. That will increase the contention on catalog.

-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join