Re: Partitioning and constraint exclusion

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Partitioning and constraint exclusion
Дата
Msg-id CALd+dccfs4RrZmXxTxe3ubBpdR=_C+RPGWxo5ghP+jvypCEa0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partitioning and constraint exclusion  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general

On Mon, Sep 7, 2015 at 4:48 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
IIRC ​The planner doesn't understand​
 
​overlaps so having a definition of:

IN (1,2,3,4,5); or nearly equivalently = ANY(ARRAY[1,2,3,4,5]))​

and a request for:

IN (1,3,5) / = ANY(ARRAY[1,3,5]) is going to get you nowhere with the planner.

The partition code does not execute your CHECK condition; it only tests to see if the query includes it explicitly. For example, if you have a split on "id % 100 = 59" for a table, then looking for id = 13059 does you no good; you have to search for "id = 13059 AND id % 100 = 59" to invoke the table exclusions.

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

Предыдущее
От: Tom Smith
Дата:
Сообщение: jsonb value retrieval performance
Следующее
От: Jayadevan M
Дата:
Сообщение: Re: Partitioning and constraint exclusion