Jonah H. Harris wrote: > On 2/28/07, Jeff Davis <[EMAIL PROTECTED]> wrote: >> That's 5 minutes of data, in the default configuration. > > Right, but I don't know anyone that keeps checkpoints at 5 minutes. > At least not on OLTP configurations.
Uhmm... most do because most don't ever touch the postgresql.conf and those that do, don't touch checkpoints because they don't understand it. Joshua D. Drake > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings