| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | how much work_mem is my server using |
| Date: | 2011-07-29 13:26:49 |
| Message-ID: | CAHnozTjZrAUzz+ywRK41PUpwSfOq+h+BppH6ASgKNzNCFyL63g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hi,
Is there a way to find out how much work_mem my server(*) is actually
using on a running system in production?
* - session or cluster. I don't mean explain analyze.
What i am really interested in is: how does postgres utilize the
memory in the server? How much goes where, in reality.
I want to sound an alarm when the server starts swapping (can do) and
be able find out if work_mem is too high.
I also want to see if work_mem gets in the way of shared_buffers or
the OS file cache. On munin for example.
So, is there a way to find out the amount of work_mem that has been allocated?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Isabella Ghiurea | 2011-07-29 15:35:21 | snapshot backup with WAL files |
| Previous Message | Alex Hunsaker | 2011-07-29 10:23:37 | Re: Regarding Postgres Upgrade |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rohan Malhotra | 2011-07-29 13:37:15 | Queries related to checkpoints |
| Previous Message | Raghavendra | 2011-07-29 08:23:55 | Re: repmgr and archive_mode |