Re: postmaster growing to consume all memory

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster growing to consume all memory
Date: 2004-01-27 15:46:17
Message-ID: 5.2.1.1.1.20040127234111.03450db8@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[my original reply to this hasn't appeared so I'm posting a shorter one]
At 07:41 PM 1/27/2004 +1100, Martijn van Oosterhout wrote:

> > 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?

Yes, about a million distinct IPs.

I downgraded to 7.3.4 and the problem doesn't occur - postmaster stays
about 4.4MB for the same query and same data. I did a vacuum full analyze
with 7.4. Whereas with 7.3 I did a vacuum full, followed by an analyze.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2004-01-27 15:51:20 Re: Where is initdb?
Previous Message Lamar Owen 2004-01-27 15:20:32 Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0