From: | "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
---|---|
To: | <pgsql-patches(at)postgresql(dot)org> |
Subject: | How can I use 2GB of shared buffers on Windows? |
Date: | 2007-02-08 12:50:26 |
Message-ID: | 02cd01c74b7f$b4baf6b0$19527c0a@OPERAO |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hello,
Could anyone tell me how to use 2GB of shared buffers on Windows? I'm
sorry for attaching large text files and for sending this mail to this
ML.
When I try to start PostgreSQL 8.2.1 on Windows 2003 Server with
shared_buffers=1024MB, I get the following error messages in the Event
Log (with log_min_messages=debug5) and can't start PostgreSQL:
DEBUG: mapped win32 error code 8 to 12
FATAL: shmat(id=1880) failed: Not enough space
This means the Win32 API MapViewOfFile() failed with error code =
ERROR_NOT_ENOUGH_MEMORY. However, the machine has 4GB of RAM and the
maximum size of paging file is 8GB.
But I could start PostgreSQL with shared_buffers=900MB. Then, I
peeked the memory map of postgres. The attached files are the memory
usage of postgres obtained by vadump. which is a tool included in
Microsoft Resource Kit (vadump is downloadable freely.)
(I'm using packaged PostgreSQL 8.2.1 available from
www.postgresql.org.)
--------------------------------------------------
Symbols loaded: 10000000 : 10107000 libeay32.dll
Symbols loaded: 1c000000 : 1c006000 comerr32.dll
Symbols loaded: 5ba20000 : 5ba77000 hnetcfg.dll
Symbols loaded: 61770000 : 61779000 LPK.DLL
--------------------------------------------------
These modules appear to be criminals. They are spliting the address
space of postgres and preventing postgres from allocating a large
shared memory. They seem to be the open source libraries (but what is
hnetcfg.dll?)
Why are they located on strange (evil) places? What can I do?
Attachment | Content-Type | Size |
---|---|---|
vadump_memmap.txt | text/plain | 13.9 KB |
vadump_modulemap.txt | text/plain | 6.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-02-08 13:31:07 | Re: [HACKERS] Dead code in _bt_split? |
Previous Message | Peter Eisentraut | 2007-02-08 11:20:37 | Re: compilation of pg_config fails |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-02-08 13:31:07 | Re: [HACKERS] Dead code in _bt_split? |
Previous Message | Magnus Hagander | 2007-02-08 11:32:55 | Re: Feature: POSIX Shared memory support |