Re: checkpoint segments

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073