checkpoint are too frequent

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: checkpoint are too frequent
Date: 2005-06-17 06:25:33
Message-ID: 674d1f8a0506162325889a0b4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

2005-06-16 23:22:20 LOG: 00000: checkpoints are occurring too
frequently (1 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".

Is this bad on the hard disk ?. or on the postgresql server?.

Can i change the checkpoints which is currently 10 to someting like 50
during FULL vacumming ?. and reload the postgresql server during the
process?.
--
Best,
Gourish Singbal

Browse pgsql-admin by date

  From Date Subject
Next Message Francesco Dalla Ca' 2005-06-17 07:50:14 Re: FATAL: invalid value for parameter "wal_sync_method":
Previous Message Din Adrian 2005-06-16 23:38:53 Re: [SQL] PostgreSQL and Delphi 6