Re: Change query priority

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.1070704@bigfoot.com>, Gaetano Mendola wrote:
> Tom Lane wrote:
> > Gaetano Mendola <mendola@bigfoot.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
>
>
>