> What are Oracle and EnterpriseDB recommending for shmmax these days?
According to Oracle "set to a value half the size of physical memory".
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
In response to
- Re: Tuning at 2007-01-31 17:25:12 from Mischa Sandberg
pgsql-performance by date
|Next:||From: Rigmor Ukuhe||Date: 2007-01-30 10:21:38|
|Subject: Re: Partitioning|
|Previous:||From: Richard Huxton||Date: 2007-01-30 10:02:33|
|Subject: Re: Querying distinct values from a large table|