"Alex Vinogradovs" <AVinogradovs@xxxxxxxxxxxxxxxx> writes: > Hello all, > > > I have a table which is partitioned by range into 10 pieces with > constraint exceptions. Constraint exceptions is enabled in server > configuration too. For some reason, queries to the master table > are still slower than direct queries against partitions. Is there > any real reason for that, or I should look into misconfiguration ? Well you have to look at the actual plans. Having to combine multiple partitions does have some cost to it and does interfere somewhat in the planner's ability to optimize plans so it might not be a win on individual queries if they were not doing big scans of unnecessary data previously. You might also consider using partial indexes instead of partitioning if your goal is just optimizing queries. The big advantage of partitioning is being able to add and drop entire partitions effectively instantaneously. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
