Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> It seems like it might be helpful, before tackling what you're
talking
> about here, to have some better tools for controlling resource
> utilization. Right now, the tools we have a pretty crude. You
can't
> even nice/ionice a certain backend without risking priority
inversion,
> and there's no sensible way to limit the amount of amount of working
> memory per-query, only per query-node.
>
> http://archives.postgresql.org/pgsql-hackers/2009-10/msg00125.php
I will review and consider. Thanks.
-Kevin