Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. - Mailing list pgsql-general

From Dave Page
Subject Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date
Msg-id 937d27e10912110108x3493359fj24c11aac80ed24f3@mail.gmail.com
Whole thread Raw
In response to Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  ("Massa, Harald Armin" <chef@ghum.de>)
Responses Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  ("Massa, Harald Armin" <chef@ghum.de>)
Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view 
On Fri, Dec 11, 2009 at 9:02 AM, Massa, Harald Armin <chef@ghum.de> wrote:
>> # - Memory -
>> shared_buffers = 512MB
>> work_mem = 256MB
> this settings would be good for PostgreSQL on Unix and Unixlike systems.
>
> I got MUCH better results by drastically lowering shared_buffers on
> Windows. Drastically = 8MB.

Wow - really? Greg and I did some rough pgbench experiments last year
and were finding the on a 4GB machine, running XP Pro, 512MB seemed to
be optimal, but it was only marginally better than 128 or 256MB. Going
lower than that made a noticable difference, and going higher we saw
performance dropping off again as well.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny
Next
From: "Massa, Harald Armin"
Date:
Subject: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.