From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Takayuki Tsunakawa <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: How can I use 2GB of shared buffers on Windows? |
Date: | 2007-02-08 14:26:35 |
Message-ID: | 20070208142635.GA28815@svr2.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Thu, Feb 08, 2007 at 09:50:26PM +0900, Takayuki Tsunakawa wrote:
> 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:
Is this for testing, or for production? From what I've heard, you would
normally never want that much shared memory - I've seen more reports on
taht you shuld keep it as low as possible, really. For performance
reasons.
> --------------------------------------------------
> 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?)
hnetcfg.dll is a part of Windows. "Home Networking Configuration
Manager". LPK.DLL is also a part of Windows - it's the language pack.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-02-08 14:47:11 | Re: HOT for PostgreSQL 8.3 |
Previous Message | Alvaro Herrera | 2007-02-08 13:59:16 | Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-02-08 14:39:05 | Re: Fwd: Re: [DOCS] [HACKERS] Broken link in PG docs |
Previous Message | Takayuki Tsunakawa | 2007-02-08 13:56:02 | Re: How can I use 2GB of shared buffers on Windows? |