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

From: "Massa, Harald Armin" <chef(at)ghum(dot)de>
To: A(dot)Bhattacharya(at)sungard(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date: 2009-12-11 09:02:25
Message-ID: e3e180dc0912110102j2d52f03dtb1fd9f76756937ae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> # - 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.

please try it. (there is no clear understanding WHY shared buffers on
Windows most often behave totally different then on unix)

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2009-12-11 09:06:48 "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny
Previous Message A. Kretschmer 2009-12-11 07:21:41 Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.