Re: work_mem and shared_buffers

[Heikki Linnakangas <heikki(at)enterprisedb(dot)com>]

Campbell, Lance wrote:
> Does the amount of memory allocate to work_mem get subtracted from
> shared_buffers?
>
> Example:
>
> If work_mem is 1M and there are 10 connections and shared_buffers is
> 100M then would the total be 90 M left for shared_buffers?
>
> Or does the amount of memory allocated for work_mem have nothing to do
> with shared_buffers?

No, they're completely separate.

Note that a connection can use more than work_mem of memory. For 
example, if you run a query with multiple Sort or hash-nodes, each such 
node allocates up to work_mem of memory.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com