Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with constraint exclusion on partitions - Mailing list pgsql-general

From David G Johnston
Subject Re: Problem with constraint exclusion on partitions
Date
Msg-id 1419057427324-5831548.post@n5.nabble.com
Whole thread Raw
In response to Problem with constraint exclusion on partitions  ("Mike Pultz" <mike@mikepultz.com>)
Responses Re: Problem with constraint exclusion on partitions
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Mike Pultz"
Date:
Subject: Problem with constraint exclusion on partitions
Next
From: "Mike Pultz"
Date:
Subject: Re: Problem with constraint exclusion on partitions