| From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | How much memory is PostgreSQL using |
| Date: | 2010-03-29 14:59:31 |
| Message-ID: | B10E6810AC2A2F4EA7550D072CDE876004B2E218@SAB-FENWICK.sab.uiuc.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
PostgreSQL 8.4.3
OS: Linux Red Hat 4.x
I changed my strategy with PostgreSQL recently to use a large segment of
memory for shared buffers with the idea of caching disk blocks. How can
I see how much memory PostgreSQL is using for this?
I tried:
ps aux | grep post | sort -k4
This lists the processes using memory at the bottom. Are they sharing
memory or using individual their own blocks of memory?
When I do top I see that VIRT is the value of my shared buffers plus a
tiny bit. I see %MEM is only 2.4%, 2.6%, 1.0%,1.5%, and 1.1% for all of
the running processes. Do I add these percentages up to see what amount
of VIRT I am really using?
Or is there some way to ask PostgreSQL how much memory are you using to
cache disk blocks currently?
When you do a PG_DUMP does PostgreSQL put the disk blocks into shared
buffers as it runs?
Thanks,
Lance Campbell
Software Architect/DBA/Project Manager
Web Services at Public Affairs
217-333-0382
| From | Date | Subject | |
|---|---|---|---|
| Next Message | randalls | 2010-03-29 16:42:48 | Performance regarding LIKE searches |
| Previous Message | admin@gifts.ru | 2010-03-29 13:59:02 | transaction overhead at "on commit delete rows"; |