Constraint exclusion involving joins

From: Krithika Venkatesh <krithikavenkatesh31(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Constraint exclusion involving joins
Date: 2017-07-27 07:33:53
Message-ID: CAP7eca0WB7zFneJBWkJ6YmtByXsz1Ev4u2PnK=JcKFV0+Jus1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Alex Samad 2017-07-27 07:43:18 Re: Question about paritioning
Previous Message Nick Brennan 2017-07-27 07:11:30 Re: Indexes being ignored after upgrade to 9.5