Thats fine, but you do understand that nice (linux) will have *no* effect on I/O?
For any non-trivial table (that can't be held entirely in memory), re-nice will almost certainly have no effect. -Barry In article <[EMAIL PROTECTED]>, Gaetano Mendola wrote: > Tom Lane wrote: > > Gaetano Mendola <[EMAIL PROTECTED]> writes: > > > >>I feel that renice a backend will not kill your system. > > > > > > It won't kill the system, but it probably won't accomplish what you > > hoped for, either. > > > > That's true but right now renice a backend is the only way to procede > in order to *try* to "slow down" some queries > > > > Regards > Gaetano Mendola > > > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend