From: | Aidan Van Dyk <aidan(at)highrise(dot)ca> |
---|---|
To: | Dan Sugalski <dan(at)sidhe(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PG 8.3 and large shared buffer settings |
Date: | 2009-09-25 13:33:09 |
Message-ID: | 20090925133309.GE586@oak.highrise.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
* Dan Sugalski <dan(at)sidhe(dot)org> [090925 06:06]:
> I'll have to go check, but I think it does. This box hasn't actually hit
> swap since it started -- a good chunk of that RAM is used as
> semi-permanent disk cache but unfortunately the regular day-to-day use of
> this box (they won't let me have it as a dedicated DB-only machine. Go
> figure :) doing other stuff the cache tends to turn over pretty quickly.
All the more reason to find a way to use it all as shared buffers and
lock it into ram...
Oh, sorry, you expect the DB to play nice with everything else?
;-)
a.
--
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2009-09-25 15:22:16 | Re: High CPU load on Postgres Server during Peak times!!!! |
Previous Message | Gerhard Wiesinger | 2009-09-25 13:00:18 | Re: High CPU load on Postgres Server during Peak times!!!! |