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