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 <416C46C2(dot)1070704(at)bigfoot(dot)com>, Gaetano Mendola wrote:
> Tom Lane wrote:
> > Gaetano Mendola <mendola(at)bigfoot(dot)com> 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
>
>
>