| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postmaster growing to consume all memory |
| Date: | 2004-01-27 08:41:29 |
| Message-ID: | 20040127084129.GA7128@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerome Lyles | 2004-01-27 09:31:25 | Permission Problems:-)? |
| Previous Message | Hadley Willan | 2004-01-27 08:13:56 | Reloading Template1 |