Обсуждение: checkpoint are too frequent

Поиск
Список
Период
Сортировка

checkpoint are too frequent

От
Gourish Singbal
Дата:
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