Re: Limit allocated memory per session - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Limit allocated memory per session
Date
Msg-id 20414.1254413898@sss.pgh.pa.us
Whole thread Raw
In response to Re: Limit allocated memory per session  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Limit allocated memory per session
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> What WOULD be useful is to find a way to provide a way to configure
> work_mem per backend rather than per executor node.  But that's a much
> harder problem.

I think it's mostly a planner problem: how do you deal with the fact
that that would make cost estimates for different sub-problems
interrelated?  The cost of a hash, for instance, depends a lot on how
much memory you assume it can use.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby on git
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Limit allocated memory per session