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

From Darren Reed
Subject Re: Is my database now too big?
Date
Msg-id 4714151F.4050307@fastmail.net
Whole thread Raw
In response to Re: Is my database now too big?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Is my database now too big?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:
> 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?
>

That's easy - I don't even have one of these files!

Darren


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is my database now too big?
Next
From: Tom Lane
Date:
Subject: Re: Is my database now too big?