Re: Need to tune for Heavy Write

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(dot)sharma(at)orkash(dot)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(at)postgresql(dot)**
> org <pgsql-performance(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-performance<http://www.postgresql.org/mailpref/pgsql-performance>
>