>I it seems that slowness is caused by grouping by column
> exchrate numeric(13,8)
exchrate has different values in few rows.
It has usually value 0
In this sample query it is always 0.
I tried not change exchrate with
but this does not up speed query, no idea why.
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2008-11-28 22:28:42|
|Subject: Re: Memory Allocation|
|Previous:||From: Scott Marlowe||Date: 2008-11-28 20:34:29|
|Subject: Re: Increasing GROUP BY CHAR columns speed|