Alvaro Herrera wrote: > > Ah; yes, what I was proposing (or thought about proposing, not sure if I > > posted it or not) was putting a upper limit of 10 seconds in the sleep > > (bgwriter sleeps 10 seconds if configured to not do anything). Though > > 10 seconds may seem like an eternity for systems like the ones Peter was > > talking about, where there is a script trying to restart the server as > > soon as the postmaster dies.
Peter, is 10 seconds good enough for you? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(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