Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: postgres on Windows: PAE and max memory
- From: Jim Nasby <decibel(at)decibel(dot)org>
- To: William Garrison <postgres(at)mobydisk(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: postgres on Windows: PAE and max memory
- Date: Mon, 30 Apr 2007 13:50:46 +0100
On Apr 24, 2007, at 8:50 PM, William Garrison wrote:
I have a server running Windows Server 2003 32-bit that has 8GB of memory. Our system administrator installed PAE (Physical Address Extensions) which I know MS SQL Server will use, but I'm not sure if PostgreSQL will.Can PostgreSQL use the memory above 2GB and 4GB?
Have you tried it? :)I don't know off-hand if it can or not, but keep in mind that unlike most databases, PostgreSQL tends to rely on the OS helping with caching, so you don't generally want to give all your memory to PostgreSQL to use.
-- Jim Nasby jim(at)nasby(dot)net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- Follow-Ups:
- Re: postgres on Windows: PAE and max memory
- From: Magnus Hagander
- Re: postgres on Windows: PAE and max memory
- References:
- postgres on Windows: PAE and max memory
- From: William Garrison
- postgres on Windows: PAE and max memory
- Prev by Date: Re: The directory of the postgresql source
- Next by Date: Re: Bitmap Scan Pages
- Previous by thread: postgres on Windows: PAE and max memory
- Next by thread: Re: postgres on Windows: PAE and max memory
- Indexes: