| 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: | Whole Thread | Raw Message | 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!!!! |