Re: [GENERAL] postmaster growing to consume all memory

2004-01-27 Thread Lincoln Yeoh
I'll try to look into that. I'm doing the processing on 7.3.4, so I'll have to find some spare resources for 7.4.1. Maybe it was a fluke or something. I did an "overwrite" make install into the same directory as the original 7.3.4 (new data directory though), so maybe I shouldn't have done that?

Re: [GENERAL] postmaster growing to consume all memory

2004-01-27 Thread Tom Lane
Lincoln Yeoh <[EMAIL PROTECTED]> writes: > No offense intended but I doubt the estimator will get things right all the > time (esp if my built-in Murphy Field Intensifier happens to be on). Doesn't mean we shouldn't strive to improve it. The present code for estimating number of groups is new in

Re: [GENERAL] postmaster growing to consume all memory

2004-01-27 Thread Martijn van Oosterhout
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 w

[GENERAL] postmaster growing to consume all memory

2004-01-27 Thread Lincoln Yeoh
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