Re: 8.3.5: Query Planner takes 15+ seconds to plan Update or Delete queries on partitioned tables.

Scott Carey <scott(at)richrelevance(dot)com> writes:
> Child tables of the table in question:
> select count (*) from pg_tables where tablename like pp_logs%';
> count
> -------
> 6062

This is not a bug. Please note the caveat in the fine manual, at the
bottom of
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html

All constraints on all partitions of the master table are
examined during constraint exclusion, so large numbers of
partitions are likely to increase query planning time
considerably. Partitioning using these techniques will work well
with up to perhaps a hundred partitions; don't try to use many
thousands of partitions.

regards, tom lane