Optimal shmem_buffers and sort memory - Mailing list pgsql-general

From Mitch Vincent
Subject Optimal shmem_buffers and sort memory
Date
Msg-id 00fc01bffbc0$546aa0f0$4100000a@doot
Whole thread Raw
List 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 by date:

Previous
From: jeff seaman
Date:
Subject: auto rollback
Next
From: "Differentiated Software Solutions Pvt. Ltd"
Date:
Subject: Postgres connect with Access