Step 1 :
Edit postgresql.conf.
sudo nano /etc/postgresql/8.3/main/postgresql.conf
Step 2 :
The performance tuning setting is as the following :
(1) shared_buffers
Recommended : 0.25 * Available Memory
(2) work_mem
Recommended : Available Memory / max_connections
(If your queries tend to be more complicated, then divide that by 2. If you typically run very close to max_connections connections, then consider dividing by 2 [...]
Filed under: FreeBSD, Linux, Ubuntu, debian, fedora | 5 Comments »