Re: Is my database now too big? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Is my database now too big?
Date
Msg-id 23809.1192485371@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is my database now too big?  (Darren Reed <darrenr@fastmail.net>)
Responses Re: Is my database now too big?  (Darren Reed <darrenr+postgres@fastmail.net>)
List pgsql-admin
Darren Reed <darrenr@fastmail.net> writes:
> Tom Lane wrote:
>> Anyway, the above error should have also produced a map of per-context
>> memory usage in the postmaster log (ie, postmaster stderr).  If you
>> could show us that, it might be revealing.

> MessageContext: 267378688 total in 43 blocks; 1768 free (45 chunks);
> 267376920 used

> The standout problem is the "MessageContext" count.

Indeed.  And there shouldn't even be anything in MessageContext until
the first client command has been received.  Maybe you have something
in ~/.psqlrc that you haven't told us about?

            regards, tom lane

pgsql-admin by date:

Previous
From: Darren Reed
Date:
Subject: Re: Is my database now too big?
Next
From: Darren Reed
Date:
Subject: Re: Is my database now too big?