Re: Tuning - Mailing list pgsql-performance

From John Parnefjord
Subject Re: Tuning
Date
Msg-id 76C73999206F3145A2E3046A5C32A103F02EA1@kibmail.kib.local
Whole thread Raw
In response to Re: Tuning  (Ron <rjpeace@earthlink.net>)
Responses Re: Tuning  ("Mischa Sandberg" <mischas@ca.sophos.com>)
List pgsql-performance
> What are Oracle and EnterpriseDB recommending for shmmax these days?

According to Oracle "set to a value half the size of physical memory".
[http://www.oracle.com/technology/tech/linux/validated-configurations/ht
ml/vc_dell6850-rhel4-cx500-1_1.html]

I've been talking to an Oracle DBA and he said that they are setting
this to something between 70-80% on a dedicated database server. As long
as one doesn't run other heavy processes and leave room for the OS.

EnterpriseDB advocates: 250 KB + 8.2 KB * shared_buffers + 14.2 kB *
max_connections up to infinity
[http://www.enterprisedb.com/documentation/kernel-resources.html]


// John

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Querying distinct values from a large table
Next
From: Rigmor Ukuhe
Date:
Subject: Re: Partitioning