Alex Vinogradovs wrote:
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 ?
Thanks!
Best regards,
Alex Vinogradovs
Is that true even if you type the query yourself in psql and ensure that
the values for the partitioned columns are constants in the where
clause? Can you post an explain of the sql?
Paul
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
