Re: postmaster growing to consume all memory - Mailing list pgsql-general

From Tom Lane
Subject Re: postmaster growing to consume all memory
Date
Msg-id 22538.1075220735@sss.pgh.pa.us
Whole thread Raw
In response to Re: postmaster growing to consume all memory  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: postmaster growing to consume all memory  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Re: postmaster growing to consume all memory  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> I'm afraid I'll have to defer to someone else (Tom?) as why the estimate was
> out by three orders of magnitude.

I'd like to know that, too.

> I'd suggest playing around with statistics and seeing if you can work out
> why they were so bad.

Could we see the pg_stats row for the ip_saddr column?  Also, does the
estimate get better if you increase the stats target for ip_saddr and
re-analyze?

            regards, tom lane

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Where is initdb?
Next
From: Tom Lane
Date:
Subject: Re: Reloading Template1