From: | "John Parnefjord" <John(dot)Parnefjord(at)kib(dot)ki(dot)se> |
---|---|
To: | "Ron" <rjpeace(at)earthlink(dot)net>, <pgsql-performance(at)postgresql(dot)org> |
Cc: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Subject: | Re: Tuning |
Date: | 2007-01-30 10:05:03 |
Message-ID: | 76C73999206F3145A2E3046A5C32A103F02EA1@kibmail.kib.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rigmor Ukuhe | 2007-01-30 10:21:38 | Re: Partitioning |
Previous Message | Richard Huxton | 2007-01-30 10:02:33 | Re: Querying distinct values from a large table |