On Thu, 2010-03-04 at 17:40 -0500, Robert Haas wrote:
On Mon, Mar 1, 2010 at 2:29 PM, Anj Adu fotogra...@gmail.com wrote:
When I use intervals in my query e.g col1 between current_timestamp -
interval '10 days' and current_timestamp...the optimizer checks ALL
partitions whereas if I use
On Mon, Mar 1, 2010 at 2:29 PM, Anj Adu fotogra...@gmail.com wrote:
When I use intervals in my query e.g col1 between current_timestamp -
interval '10 days' and current_timestamp...the optimizer checks ALL
partitions whereas if I use col1 between 2 hardcoded dates..only
the applicable
When I use intervals in my query e.g col1 between current_timestamp -
interval '10 days' and current_timestamp...the optimizer checks ALL
partitions whereas if I use col1 between 2 hardcoded dates..only
the applicable partitions are scanned.
--
Sent via pgsql-performance mailing list