Home > mailing lists

work_mem and shared_buffers - Mailing list pgsql-performance

From	Campbell, Lance
Subject	work_mem and shared_buffers
Date	November 9, 2007 16:49:03
Msg-id	B10E6810AC2A2F4EA7550D072CDE8760197DE4@SAB-FENWICK.sab.uiuc.edu Whole thread Raw
Responses	Re: work_mem and shared_buffers
List	pgsql-performance

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?

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

From: "Scott Marlowe"
Date: 09 November 2007, 15:56:12
Subject: Re: dell versus hp

From: Heikki Linnakangas
Date: 09 November 2007, 16:56:40
Subject: Re: work_mem and shared_buffers