On 07.10.2010 10:09, Vincenzo Romano wrote:
Any feedbacks from TGL and Heikki, then?
I don't have anything to add to what others said already. Your best advice is to test it yourself.
I would expect the plan time to be linear relative to the number of partial indexes or child tables involved, except that constraint exclusion of CHECK constraints on the partitions is exponential. But I also wouldn't be surprised if there's some other non-linear aspect there that shows its head with thousands of partitions.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
