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 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

Re: [PERFORM] partition pruning

2010-03-04 Thread Robert Haas
On Mon, Mar 1, 2010 at 2:29 PM, Anj Adu 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 partitions are scanne

[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 (pgsql-p