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.

---------------------------------------------------------------------------

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