There was a problem with this setting that it reports during shutdown when in fact it should ignore shutdown checkpoints. This is fixed in 8.1. --------------------------------------------------------------------------- Havasvölgyi Ottó wrote: > Hi, > > I have a small database on my Windows XP, I rarely use it. Even so, the log > file show says this: > > [2005-07-02 02:02:09] LOG: received fast shutdown request > > [2005-07-02 02:02:09] LOG: checkpoints are occurring too frequently (0 > seconds apart) > > [2005-07-02 02:02:09] HINT: Consider increasing the configuration > parameter "checkpoint_segments". > > [2005-07-02 02:02:09] LOG: shutting down > > [2005-07-02 02:02:10] LOG: database system is shut down > > [2005-07-02 02:02:13] LOG: logger shutting down > > > My checkpoint_segments setting is default, 3, and there are 2 wal log files. > Why does it say, that "too frequenty"? > In fact what are checkpoints? These files? I couldn't understand it exactly > from the docs. > > Thanks, > Otto > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
