Skip site navigation (1) Skip section navigation (2)

Re: Limit allocated memory per session

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Euler Taveira de Oliveira <euler(at)timbira(dot)com>, daveg <daveg(at)sonic(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Limit allocated memory per session
Date: 2009-10-01 15:50:54
Message-ID: 603c8f070910010850k549f8d80nc940e82ebbe768f2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Oct 1, 2009 at 11:47 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Euler Taveira de Oliveira <euler(at)timbira(dot)com> writes:
>> Tom Lane escreveu:
>>> daveg <daveg(at)sonic(dot)net> writes:
>>>> I'd like to propose adding a new GUC to limit the amount of memory a backend
>>>> can allocate for its own use.
>>>
>>> Use ulimit.
>>>
>> What about plataforms (Windows) that don't have ulimit?
>
> Get a real operating system ;-)
>
> Seriously, the proposed patch introduces overhead into a place that is
> already a known hot spot, in return for not much of anything.  It will
> *not* bound backend memory use very accurately, because there is no way
> to track raw malloc() calls.  And I think that 99% of users will not
> find it useful.

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.

...Robert

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2009-10-01 15:56:09
Subject: Re: FSM search modes
Previous:From: Heikki LinnakangasDate: 2009-10-01 15:48:29
Subject: Re: Hot Standby on git

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group