[GENERAL] Constraint exclusion involving joins - Mailing list pgsql-general

From Krithika Venkatesh
Subject [GENERAL] Constraint exclusion involving joins
Date
Msg-id CAP7eca0WB7zFneJBWkJ6YmtByXsz1Ev4u2PnK=JcKFV0+Jus1A@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi, 
 
I understand that the constraints exclusion will work only on constant values. But in my case, I will never pass a constant value to the partitioning key when we query the partition table. Will the partition be still be beneficial in this case. If yes, can you please explain

Thanks


pgsql-general by date:

Previous
From: Nick Brennan
Date:
Subject: Re: [GENERAL] Indexes being ignored after upgrade to 9.5
Next
From: Alex Samad
Date:
Subject: Re: [GENERAL] Question about paritioning