Re: Proposal: backend "niceness" / session_priority

José Luis Tallón <jltallon@adv-solutions.net> writes:
>      Since PostgreSQL lacks the resource management capabilities of the 
> "Big Ones" ( Resource Groups - Red, WorkLoad Manager - Blue ) or the 
> Resource Governor in MS SQL Server, we can try and approximate the 
> requested behaviour by reducing the CPU priority ("nice") of the backend 
> in question. Please note that we would be using scheduler priority to 
> try and modulate I/O, though I'm aware of the limitations of this mechanism.

This has been proposed before, and rejected before, and I'm not seeing
anything particularly new here.  Without a credible mechanism for
throttling I/O, "nice" alone does not seem very promising.
        regards, tom lane