Re: BUG #16745: delete does not prune partitions on declarative partitioned table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16745: delete does not prune partitions on declarative partitioned table
Дата
Msg-id 572035.1606341481@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16745: delete does not prune partitions on declarative partitioned table  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16745: delete does not prune partitions on declarative partitioned table  (Christian <akattunga@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
PG Bug reporting form <noreply@postgresql.org> writes:
> If I execute:
> select * FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND
> FFECHAI=current_date;
> it use only one partition
> but:
> delete FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND
> FFECHAI=current_date;
> scan all partitions

> Is there any regression?

No.  There's work afoot to improve this, but it wasn't any better before.

            regards, tom lane

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

Предыдущее
От: Christian
Дата:
Сообщение: Re: BUG #16745: delete does not prune partitions on declarative partitioned table
Следующее
От: Christian
Дата:
Сообщение: Re: BUG #16745: delete does not prune partitions on declarative partitioned table