| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Darren Reed <darrenr(at)fastmail(dot)net> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Is my database now too big? |
| Date: | 2007-10-15 16:03:10 |
| Message-ID: | 17093.1192464190@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Darren Reed <darrenr(at)fastmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jessica Richard | 2007-10-15 17:18:24 | Re: Is there a way to kill a connection from the pg_stat_activitly list? |
| Previous Message | Jonah H. Harris | 2007-10-15 15:42:40 | Re: Distributed DataBases |