Re: postmaster out of memory....

On Fri, Feb 27, 2004 at 01:45:07PM -0500, Joe Maldonado wrote:
> Hello all!
>
>     when asking postgres to aggregate totals accross 4.5 or so Million
>     records.  The visible effect is that the postmaster will grow to the
>     3GB process limit and die without a core :(.
> I have seen this same behaviour discussed back in 6.5 archives in the
> thread with subject "[SQL] How to avoid "Out of memory" using aggregate
> functions? ".  Is this fixed? Why is the postmaster exceeding it's 102MB
> sort mem size when doing these queries and not paging out the data?

What version? We aggregate million of value vairly often. What
aggregate?

Have you run ANALYZE recently?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow