[BUGS] BUG #14263: Query planner is slow to plan UPDATE on a table with many partitions

Поиск
Список
Период
Сортировка
От Joel Sanger
Тема [BUGS] BUG #14263: Query planner is slow to plan UPDATE on a table with many partitions
Дата
Msg-id CABaOQpwxr=5zEfq7HOJdRdThLp3wrz59rz7n4w3DwtSy76zN3w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14263: Query planner is slow to plan UPDATE on atable with many partitions  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-bugs
Дерево обсуждения
Hi all, 

Just to keep this bug current, I am also experiencing the same issue. I'm using PostgreSQL 9.6.1 on Debian 8.6.

As an example, i have a table with a *very* large number of partitions. A simple select clause has a planning time of 600ms where as the same clause as an update results in a 8300ms planning time.

Unfortunately the partitioning scheme we have is ideal for our regular workflow, so using less partitions isn't practical.

If there's any update, plans to fix (or not) that would be appreciated.

Thanks, 
Joel

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

Предыдущее
От: Вадим Акбашев
Дата:
Сообщение: [BUGS] Strange influence of default_statistics_target
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: [BUGS] pg_dump 9.6 doesn't honour pg_extension_config_dump for sequences