Re: [GENERAL] Checkpoint segments too small

2007-08-06 Thread Magnus Hagander
On Mon, Aug 06, 2007 at 11:26:18AM +0200, Henrik Zagerholm wrote: > Hi list, > > I'm running 8.2.4 and I've started to get these messages and even > though I googled for some answers I couldn't find any good info > against the 8.2 code base. > > 2007-08-05 04:00:58.815 CEST LOG: checkpoints

[GENERAL] Checkpoint segments too small

2007-08-06 Thread Henrik Zagerholm
Hi list, I'm running 8.2.4 and I've started to get these messages and even though I googled for some answers I couldn't find any good info against the 8.2 code base. 2007-08-05 04:00:58.815 CEST LOG: checkpoints are occurring too frequently (17 seconds apart) 2007-08-05 04:00:58.815 CES

Re: [GENERAL] checkpoint segments

2005-07-09 Thread Bruce Momjian
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

Re: [GENERAL] checkpoint segments

2005-07-09 Thread Havasvölgyi Ottó
Hi, Sorry, this is Pg 8.0.3 Regards, Otto ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] checkpoint segments

2005-07-09 Thread Havasvölgyi Ottó
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 increasi