Optimal shmem_buffers and sort memory

Поиск
Список
Период
Сортировка
От Mitch Vincent
Тема Optimal shmem_buffers and sort memory
Дата
Msg-id 00fc01bffbc0$546aa0f0$4100000a@doot
обсуждение исходный текст
Список pgsql-general
I have a pretty beefy machine as a production server and want to tune the
postmaster as much as I can to take advantage.

I don't want to get outrageous with the shmem_buffers ( -B ) and sort_mem
( -S ) but don't know what outrageous would really be.

Could any provide some explanation and/or tips with regard to correctly
using the shmem_buffers and sort_mem options?

Thanks!

-Mitch


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

Предыдущее
От: jeff seaman
Дата:
Сообщение: auto rollback
Следующее
От: "Differentiated Software Solutions Pvt. Ltd"
Дата:
Сообщение: Postgres connect with Access