Re: Needed: Simplified guide to optimal memory configuration

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: Needed: Simplified guide to optimal memory configuration
Дата
Msg-id Pine.LNX.4.44.0506151123510.1139-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Needed: Simplified guide to optimal memory configuration  (Todd Landfried <tlandfried@viatornetworks.com>)
Ответы Re: Needed: Simplified guide to optimal memory configuration  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Needed: Simplified guide to optimal memory configuration  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Дерево обсуждения 
On Wed, 15 Jun 2005, Todd Landfried wrote:

> So, what I need is to be pointed to (or told) what are the best
> settings for our database given these memory configurations.  What
> should we do?

Maybe this will help:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

> NOTICE:  shared_buffers is 256

This looks like it's way too low. Try something like 2048.

--
/Dennis Björklund

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

Предыдущее
От: Todd Landfried
Дата:
Сообщение: Needed: Simplified guide to optimal memory configuration
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Needed: Simplified guide to optimal memory configuration