Re: Problem with constraint exclusion on partitions

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with constraint exclusion on partitions
Date: 2014-12-20 06:37:07
Message-ID: 1419057427324-5831548.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Pultz wrote
> Is there something I'm missing?

What version are you using?

Now() is a volatile function so the planner cannot omit partitions.

Replace that with a constant and now it can.

David J.

--
View this message in context: http://postgresql.nabble.com/Problem-with-constraint-exclusion-on-partitions-tp5831541p5831548.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Pultz 2014-12-20 07:25:22 Re: Problem with constraint exclusion on partitions
Previous Message Mike Pultz 2014-12-20 02:35:14 Problem with constraint exclusion on partitions