Re: Shared buffers, Sort memory, Effective Cache Size

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Shared buffers, Sort memory, Effective Cache Size
Дата
Msg-id acjs80tbjoqf9gktcm8l3qrs8g0614j7ss@email.aon.at
обсуждение исходный текст
Ответ на Re: Shared buffers, Sort memory, Effective Cache Size  (Qing Zhao <qzhao@supplyfx.com>)
Список pgsql-performance
On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao@supplyfx.com>
wrote:
>I have recently configured my PG7.3 on a G5 (8GB RAM) with
>shmmax set to 512MB and shared_buffer=50000, sort_mem=4096
>and effective cache size = 10000.  It seems working great so far but
>I am wondering if I should make effctive cache size larger myself.

Yes, much larger!  And while you are at it make shared_buffers smaller.

Servus
 Manfred

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] is a good practice to create an index on the
Следующее
От: "Atesz"
Дата:
Сообщение: Re: planner/optimizer question