Re: [PERFORM] partition pruning

2010-03-08 Thread Simon Riggs
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

Re: [PERFORM] partition pruning

2010-03-04 Thread Robert Haas
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

[PERFORM] partition pruning

2010-03-01 Thread Anj Adu
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