Euler Taveira de Oliveira <eu...@timbira.com> writes: > I see. Tough problem is: how do we get per backend memory usage accurately? Is > it relying on OS specific API the only way?
Given all the third-party libraries (perl, python, libxml2, yadda yadda) that can be in use and won't go through palloc, I think that this would have to be done at the OS level to be very meaningful. The other problem is the one Robert touched on: what you actually *want* is something entirely different, namely for the backend to actively try to meet an overall target for its memory usage, rather than having queries fail ungracefully when they hit an arbitrary limit that the planner didn't even know about. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers