| 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: | Whole Thread | Raw Message | 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? |