> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
