Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-10 Thread Magnus Hagander
Takayuki Tsunakawa wrote: From: Magnus Hagander [EMAIL PROTECTED] Right. Which is why you're likely to see better performance if you keep shared buffers smaller. There is something in dealing with it that's slow on win32, per reports from the field. It needs to be investigated further...

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-09 Thread Takayuki Tsunakawa
From: Magnus Hagander [EMAIL PROTECTED] Right. Which is why you're likely to see better performance if you keep shared buffers smaller. There is something in dealing with it that's slow on win32, per reports from the field. It needs to be investigated further... We've had reports that it's

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-09 Thread Magnus Hagander
On Fri, Feb 09, 2007 at 01:06:13PM +0900, Takayuki Tsunakawa wrote: On Thu, Feb 08, 2007 at 09:50:26PM +0900, Takayuki Tsunakawa wrote: 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

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-09 Thread Martijn van Oosterhout
On Fri, Feb 09, 2007 at 07:31:33PM +0900, Takayuki Tsunakawa wrote: 1. PostgreSQL tries to read data from disk into database cache. 2. The kernel tries to allocate filesystem buffers by paging out PostgreSQL's memory (possibly shared buffers). 3. PostgreSQL finds data requested by its clients

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-09 Thread Tom Lane
Takayuki Tsunakawa [EMAIL PROTECTED] writes: I wonder whether the field you are talking about set Windows to use more memory for programs than for filesystem cache, which is selectable from [System] applet of Control Panel (Oh, I wonder how my machine is set in this respect... have to check.)

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-09 Thread Magnus Hagander
On Fri, Feb 09, 2007 at 09:49:25AM -0500, Tom Lane wrote: Takayuki Tsunakawa [EMAIL PROTECTED] writes: I wonder whether the field you are talking about set Windows to use more memory for programs than for filesystem cache, which is selectable from [System] applet of Control Panel (Oh, I

Re: [HACKERS] [PATCHES] How can I use 2GB of shared buffers on Windows?

2007-02-08 Thread Takayuki Tsunakawa
From: Magnus Hagander [EMAIL PROTECTED] hnetcfg.dll is a part of Windows. Home Networking Configuration Manager. LPK.DLL is also a part of Windows - it's the language pack. Thank you for information. On Thu, Feb 08, 2007 at 09:50:26PM +0900, Takayuki Tsunakawa wrote: When I try to start