Marc G. Fournier wrote: > On Wed, 3 Sep 2003, Bruce Momjian wrote: > > > Vivek Khera wrote: > > > the restore complained often about checkpoints occurring every few > > > seconds: > > > > > > Sep 2 11:57:14 d02 postgres[49721]: [5-1] LOG: checkpoints are occurring too > > > frequently (15 seconds apart) > > > Sep 2 11:57:14 d02 postgres[49721]: [5-2] HINT: Consider increasing > > > CHECKPOINT_SEGMENTS. > > > > > > The HINT threw me off since I had to set checkpoint_segments in > > > postgresql.conf, where as CHECKPOINT_SEGMENTS implied to me a > > > compile-time constant. > > > > Woo hoo, my warning worked. Great. > > > > I uppercased it because config parameters are uppercased in the > > documentation. Do we mention config parameters in any other error > > messages? Should it be lowercased? > > k, to me upper case denotes a compiler #define, so I would have been > confused ... I'd go with lower case and single quotes around it to denote > its a variable to be changed ...
Done. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html