Re: postmaster growing to consume all memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster growing to consume all memory
Date: 2004-01-28 05:42:19
Message-ID: 7818.1075268539@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> 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 7.4 and I'm sure there are things
that need to be done to it. I'd like to think that factor-of-1000
errors on simple cases are not the best we can do.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dean Grubb 2004-01-28 06:01:32 Help, I've killed my system?
Previous Message Lincoln Yeoh 2004-01-28 05:39:22 Re: postmaster growing to consume all memory