Re: PG 8.3 and large shared buffer settings

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: PG 8.3 and large shared buffer settings
Дата
Msg-id 20090925133309.GE586@oak.highrise.ca
обсуждение исходный текст
Ответ на Re: PG 8.3 and large shared buffer settings  (Dan Sugalski <dan@sidhe.org>)
Ответы Re: PG 8.3 and large shared buffer settings  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
* Dan Sugalski <dan@sidhe.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@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gerhard Wiesinger
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!
Следующее
От: Craig James
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!