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 <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
