Message-ID: <4E3A268C.9090409@orkash.com>
Date: Thu, 04 Aug 2011 10:26:44 +0530
From: Adarsh Sharma <adarsh.sharma@orkash.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090625)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Need to tune for Heavy Write
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear all,

 From the last few days, I researched a lot on Postgresql Performance 
Tuning due to slow speed of my server.
My application selects data from mysql database about 100000 rows , 
process it & insert into postgres 2 tables by making about 45 connections.

I set my postgresql parameters in postgresql.conf as below: ( OS : 
Ubuntu, RAM : 16 GB, Postgres : 8.4.2 )

max_connections    = 80
shared_buffers    = 2048MB
work_mem = 32MB
maintenance_work_mem = 512MB
fsync=off 
full_page_writes=off 
synchronous_commit=off 
checkpoint_segments = 32
checkpoint_completion_target = 0.7      
effective_cache_size = 4096MB


After this I change my pg_xlog directory to a separate directory other 
than data directory by symlinking.


By Application issue insert statements through postgresql connections only.

Please let me know if I missing any other important configuration.


Thanks