Re: Problem with default partition pruning

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Problem with default partition pruning
Дата
Msg-id 20190813152517.GA9767@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Problem with default partition pruning  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Problem with default partition pruning  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
On 2019-Aug-13, Amit Langote wrote:

> Thanks a lot for revising.  Looks neat, except:
> 
> +     * This is a measure of last resort only to be used because the default
> +     * partition cannot be pruned using the steps; regular pruning, which is
> +     * cheaper, is sufficient when no default partition exists.
> 
> This text appears to imply that the default can *never* be pruned with
> steps.  Maybe, the first sentence should read something like: "...the
> default cannot be pruned using the steps generated from clauses that
> contradict the parent's partition constraint".

Thanks!  I have pushed it with this change.

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



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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Built-in connection pooler
Следующее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.