Re: Memory Question - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Memory Question
Date
Msg-id 43A9CB43.4060308@commandprompt.com
Whole thread Raw
In response to Memory Question  ("Benjamin Arai" <barai@cs.ucr.edu>)
List pgsql-general
Benjamin Arai wrote:

> A machine with 4GB of memory has the ability to allocate 2GB to
> postgres under kenel 2.6.  Is the 2GB maximum the sum total of
> (work_mem, maitenance_work_mem, and shared_memory) or just
> shared_memory?

shared_memory and if I recall correctly that is adjustable but I don't
know for a fact.

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/


pgsql-general by date:

Previous
From: "Benjamin Arai"
Date:
Subject: Memory Question
Next
From: Peter Eisentraut
Date:
Subject: Re: Indices for select count(*)?