Postgres Pro
Downloads
Home   >   mailing lists

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

From Joel Sanger
Subject [BUGS] BUG #14263: Query planner is slow to plan UPDATE on a table with many partitions
Date
Msg-id CABaOQpwxr=5zEfq7HOJdRdThLp3wrz59rz7n4w3DwtSy76zN3w@mail.gmail.com
Whole thread Raw
Responses Re: [BUGS] BUG #14263: Query planner is slow to plan UPDATE on atable with many partitions  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Вадим Акбашев
Date:
Subject: [BUGS] Strange influence of default_statistics_target
Next
From: Daniele Varrazzo
Date:
Subject: [BUGS] pg_dump 9.6 doesn't honour pg_extension_config_dump for sequences