| From: | adey <adey11(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "PostgreSQL Admin" <postgres(at)productivitymedia(dot)com>, postgresql-l <postgresql-l(at)Groups(dot)ittoolbox(dot)com> |
| Subject: | What's using all my RAM? |
| Date: | 2006-08-02 04:09:43 |
| Message-ID: | 1c66bda80608012109x125180eeh38674c853ea50434@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Please could someone tell me how to discover what is using all of my RAM?
I am trying to run a vacuum against Postgres, but it fails immediately
with:-
"ERROR: out of memory
DETAIL: Failed on request of size 1073741820."
TOP shows the following:-
Mem: 4077544k total, 3897868k used, 179676k free, 146960k buffers
Swap: 2000084k total, 440k used, 1999644k free, 3352892k cached
None of the listed processes appear to be using more than 1 or 2% MEM.
Postgres v7.4.2 (upgrade underway)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-02 04:37:47 | Re: What's using all my RAM? |
| Previous Message | Chris Mair | 2006-08-01 21:56:04 | Re: Controlling CPU Usage in PostgreSQL |