Hi Adarsh, Have you set checkpoint_segments and checkpoint_completion_target the right way?
Tuning these parameters are a MUST if you want good write performance. See this link for more information: http://www.postgresql.org/docs/current/static/runtime-config-wal.html<http://www.postgresql.org/docs/current/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS> Cheers, Dusan On Thu, Aug 4, 2011 at 6:56 AM, Adarsh Sharma <adarsh.sha...@orkash.com>wrote: > 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 > > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.** > org <pgsql-performance@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-performance<http://www.postgresql.org/mailpref/pgsql-performance> >
