Re: 8.3.5: Query Planner takes 15+ seconds to plan Update or Delete queries on partitioned tables. - Mailing list pgsql-bugs

Scott Carey <scott@richrelevance.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