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

Greg,

>8MB working out best is
> really unexpected though; I'd like to know what you were doing where *that*
> was the optimal setting.

Developer machine, XP professional, 1 Gig memory. other applications
are running, ~2-4 concurrent acceses to PostgreSQL. Value was in the
200MB range, system trashed the harddrive badly. Setting down to 8MB,
and DB acesses AND the rest of the system run much smoother. Did not
benchmark queries; difference between settings was too obvious (from
many seconds down to <2 seconds)

A server (2Gig, win2003, 8.4) is set to 32MB and runs as smoothly as with 128.

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