| From: | "Massa, Harald Armin" <chef(at)ghum(dot)de> |
|---|---|
| To: | Dave Page <dpage(at)pgadmin(dot)org> |
| Cc: | pgsql-general <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:25:42 |
| Message-ID: | e3e180dc0912110125p5c1cfd5ep7dd8a09acc88cf7e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>> 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.
Yes, really, I am astonished too. Necessary information: it is a very
low concurrency workload, and system is as low as 1GB.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2009-12-11 12:52:54 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |
| Previous Message | Dave Page | 2009-12-11 09:08:13 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |