Re: shared_buffers advice

Поиск
Список
Период
Сортировка
От Dave Crooke
Тема Re: shared_buffers advice
Дата
Msg-id AANLkTimvyRfRY2TT9WV18VlC3rUKYj_2iKYWBGneHc1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: shared_buffers advice  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
If, like me, you came from the Oracle world, you may be tempted to throw a ton of RAM at this. Don't. PG does not like it.

On Fri, May 28, 2010 at 4:11 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, May 24, 2010 at 12:25 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> *) shared_buffers is one of the _least_ important performance settings
> in postgresql.conf

Yes, and no.  It's usually REALLY helpful to make sure it's more than
8 or 24Megs.  But it doesn't generally need to be huge to make a
difference.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: shared_buffers advice
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: shared_buffers advice