Postgres Pro
Downloads
Home   >   mailing lists

checkpoint are too frequent - Mailing list pgsql-admin

From Gourish Singbal
Subject checkpoint are too frequent
Date
Msg-id 674d1f8a0506162325889a0b4@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view 
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:

Previous
From: David
Date:
Subject: Re: Connecting via localhost pg-8.0.3
Next
From: Francesco Dalla Ca'
Date:
Subject: Re: FATAL: invalid value for parameter "wal_sync_method":