Re: postmaster growing to consume all memory

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