Re: [GENERAL] Help speeding up a left join aggregate

2012-02-01 Thread Volodymyr Kostyrko
Nick wrote: I have a pretty well tuned setup, with appropriate indexes and 16GB of available RAM. Should this be taking this long? I forced it to not use a sequential scan and that only knocked a second off the plan. QUERY PLAN ---

Re: [GENERAL] Help speeding up a left join aggregate

2012-01-31 Thread Alban Hertroys
On 31 Jan 2012, at 4:55, Nick wrote: > I have a pretty well tuned setup, with appropriate indexes and 16GB of > available RAM. Should this be taking this long? I forced it to not use > a sequential scan and that only knocked a second off the plan. > >

[GENERAL] Help speeding up a left join aggregate

2012-01-31 Thread Nick
I have a pretty well tuned setup, with appropriate indexes and 16GB of available RAM. Should this be taking this long? I forced it to not use a sequential scan and that only knocked a second off the plan. QUERY PLAN --