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 17093.1192464190@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?
Re: Is my database now too big?
List pgsql-admin
Darren Reed <darrenr@fastmail.net> writes:
> # /usr/pkg/bin/psql -U postgres template1
> psql: FATAL:  out of memory
> DETAIL:  Failed on request of size 20.

I'm starting to think there is something very broken about your machine :-(.
Have you run any hardware diagnostics on it lately?  The level of
flakiness you're seeing starts to suggest bad RAM to me.

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.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Distributed DataBases
Next
From: Jessica Richard
Date:
Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?