PostgreSQL 9.0 High Performance

Shared server guidelines

If your database server is sharing hardware with another use, particularly the common situation where a database-driven application is installed on the same system, you cannot be nearly as aggressive in your tuning as described in the last section. An exact procedure is harder to outline. What you should try to do is use tuning values for the memory-related values on the low side of recommended practice:

• Only dedicate 10 percent of RAM to shared_buffers at first, even on platforms where more would normally be advised
• Set effective_cache_size to 50 percent or less of system RAM, perhaps less if you know your application is going to be using a lot of it
• Be very stingy about increases to work_mem

The other suggestions in the ...