| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Миша Тюрин <tmihail(at)bk(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: high io BUT huge amount of free memory |
| Date: | 2013-05-02 12:49:03 |
| Message-ID: | 518260BF.10902@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 05/01/2013 06:37 PM, Bruce Momjian wrote:
> Sorry to be dense here, but what is the problem with that output?
> That there is a lot of memory marked as "free"? Why would it mark
> any memory free?
That's kind of my point. :) That 14GB isn't allocated to cache, buffers,
any process, or anything else. It's just... free. In the middle of the
day, where 800 PG threads are pulling 7000TPS on average. Based on that
scenario, I'd like to think it would cache pretty aggressively, but
instead, it's just leaving 14GB around to do absolutely nothing.
It makes me sad. :(
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-05-02 14:01:28 | Re: \watch stuck on execution of commands returning no tuples |
| Previous Message | Simon Riggs | 2013-05-02 12:27:28 | Re: In progress INSERT wrecks plans on table |