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 Massa, Harald Armin
Subject Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date
Msg-id e3e180dc0912110102j2d52f03dtb1fd9f76756937ae@mail.gmail.com
Whole thread Raw
In response to Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (<A.Bhattacharya@sungard.com>)
Responses Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Dave Page <dpage@pgadmin.org>)
List pgsql-general
Tree view 
> # - 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

pgsql-general by date:

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