Re: Issue for partitioning with extra check constriants

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Issue for partitioning with extra check constriants
Дата
Msg-id 1548.1285977377@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Issue for partitioning with extra check constriants  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Issue for partitioning with extra check constriants  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> The issue is this: when a partitioned table is evaluated by the planner
> for constraint exclusion, it evaluates ALL check constraints on each
> partition, regardless of whether or not they include a referenced column
> in the query (and whether or not they relate to partitioning).

[ shrug ... ]  We do not promise that the current partitioning scheme
scales to the number of partitions where this is likely to be an
interesting concern.

*After* we have a real partitioning scheme, it might be worth worrying
about this sort of problem, if it's still a problem then.

> Are we talking "moderate", "hard" or "nearly impossible"?

We're talking "wasted effort on a dead-end situation".  The time that
would go into this would be much better spent on real partitioning.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Issue for partitioning with extra check constriants
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Issue for partitioning with extra check constriants