Re: More shared_buffers instead of effective_cache_size?

Поиск
Список
Период
Сортировка
От Ulrich
Тема Re: More shared_buffers instead of effective_cache_size?
Дата
Msg-id 48C0395C.4000806@gmx.net
обсуждение исходный текст
Ответ на Re: More shared_buffers instead of effective_cache_size?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: More shared_buffers instead of effective_cache_size?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe wrote:
> Stop using a virtual server?
That is not possible...
> I wouldn't set shared_buffers that high
> just because things like vacuum and sorts need memory too
Okay, I understand that vacuum uses memory, but I thought sorts are done
in work_mem? I am only sorting the result of one query which will never
return more than 500 rows.

-Ulrich

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: slow update of index during insert/copy
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: More shared_buffers instead of effective_cache_size?