Skip site navigation (1) Skip section navigation (2)

Re: PG 8.3 and large shared buffer settings

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 (view raw or flat)
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.

In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2009-09-25 15:22:16
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Previous:From: Gerhard WiesingerDate: 2009-09-25 13:00:18
Subject: Re: High CPU load on Postgres Server during Peak times!!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group