Re: performance problem

Поиск
Список
Период
Сортировка
От Rick Gigger
Тема Re: performance problem
Дата
Msg-id 01e401c3afb4$b56cdb10$0700a8c0@trogdor
обсуждение исходный текст
Ответ на Re: performance problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
> "Rick Gigger" <rick@alpinenetworking.com> writes:
> > I am confused.  In this tutorial (by Bruce Momjian)
> > http://candle.pha.pa.us/main/writings/pgsql/hw_performance/node8.html
> > it says: "As a start for tuning, use 25% of RAM for cache size, and 2-4%
for
> > sort size."
>
> That advice is widely considered obsolete --- it was developed in the
> days when typical RAM sizes were a lot less than today.  I don't believe
> anyone has shown a good case for setting shared_buffers much higher than
> 10000.
>
> regards, tom lane

Thank you!


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

Предыдущее
От: "Rick Gigger"
Дата:
Сообщение: Re: performance problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: nodeRead: did not find '}' [x2]