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