Re: [ADMIN] Tuning postgres for high volume applications

[Peter Vazsonyi]

On Wed, 15 Mar 2000, Brian Baquiran wrote:

> > 3) Turn off flush to disk
> > (option -F )
> > (very little risk)
If this parameter is set, increase much the speed of fast periodic inserts,
updates. Because if postgres run without -F, every single statement generate
a sync() syscall.
> I'd rather not risk this...
Use an UPS. When somebody turn off the current, the UPS will send a signal,
which causes a clean shutdown. (including this ominosus sync, and whats is
more: fully correct umounts ;)
--
 nek;(