Re: postmaster growing to consume all memory

On Tue, Jan 27, 2004 at 03:42:09PM +0800, Lincoln Yeoh wrote:
> Hi,
>
> I recently upgraded to postgresql 7.4 and I am having a problem with
> postmaster using lots of memory for a query (keeps growing even up to
> 400MB+ till I stop postgresql ). I don't recall this ever happening with
> 7.3 with the exact same query but on different data (just as much data tho,
> or even more). Happened on 7.4 so I upgraded to 7.4.1. Is HashAggregate
> something new in 7.4? If I have time and disk space I'll downgrade to 7.3.3
> and see if it happens there. How do I configure a memory consumption limit
> on a 7.4 postgresql without killing it?

How many distinct IPs are there? The planner estimating around 1500.

Is it much more than that?

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce