Tom Lane wrote:
... >your sum would overflow an int4? It may be that just fixing the >inefficient date_trunc calc will reduce your
memoryrequirements >enough to get by. If not, the only good news I have is that release >7.0 does fix the memory-leak
problemfor internal calculations of >aggregate functions like sum(). You can get the first beta release >for 7.0 now.
I'm putting together a Debian release of the beta at the moment.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key
ID32B8FAA1 ======================================== "Thy word is a lamp unto my feet, and a light
untomy path." Psalms 119:105