Re: Memory usage and configuration settings - Mailing list pgsql-general

From Tom Lane
Subject Re: Memory usage and configuration settings
Date
Msg-id 13258.1330967604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory usage and configuration settings  (Mike C <smith.not.western@gmail.com>)
List pgsql-general
Mike C <smith.not.western@gmail.com> writes:
> Ok, that makes sense. With regards to work_mem, am I right in thinking
> the child processes only allocate enough memory to meet the task at
> hand, rather than the full 16M specified in the config file?

They only allocate what's needed ... but you have to keep in mind that
work_mem is *per operation*, eg per sort or hash.  A complex query could
require several such steps and thus eat several times work_mem.

            regards, tom lane

pgsql-general by date:

Previous
From: Mike C
Date:
Subject: Re: Memory usage and configuration settings
Next
From: Merlin Moncure
Date:
Subject: Re: Return unknown resultset from a function