Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> You can basically renice the process that is performing the query.
However, that's unlikely to do anything very pleasant, since you'll have
priority-inversion problems. "nice" has no idea when the process is
holding a lock that someone else wants ...
regards, tom lane