Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group