I was thinking to increase checkpoint_segments to around 16 or 20. I think 50 is a bit higher.
Greg, Sure. I would collect the info from pg_stat_bgwriter on regular intervals. As we have too many transactions going on I am thinking to collect the info every 6 or 8 hrs. Thanks VB On Wed, Oct 5, 2011 at 4:02 AM, Greg Smith <g...@2ndquadrant.com> wrote: > On 10/04/2011 03:50 AM, Venkat Balaji wrote: > >> I had a look at the pg_stat_bgwriter as well. >> > > Try saving it like this instead: > > select now(),* from pg_stat_bgwriter; > > And collect two data points, space a day or more apart. That gives a lot > more information about the rate at which things are actually happening. The > long-term totals are less interesting than that. > > Generally the first round of tuning work here is to increase > checkpoint_segments until most checkpoints appear in checkpoints_timed > rather than checkpoints_req. After that, increasing checkpoint_timeout > might also be useful. > > -- > Greg Smith 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD > PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us > > > > -- > 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> >
