Re: How can I use 2GB of shared buffers on Windows?

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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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?