| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | "Massa, Harald Armin" <chef(at)ghum(dot)de> |
| Cc: | "A(dot)Bhattacharya" <A(dot)Bhattacharya(at)sungard(dot)com>, 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:08:13 |
| Message-ID: | 937d27e10912110108x3493359fj24c11aac80ed24f3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 11, 2009 at 9:02 AM, Massa, Harald Armin <chef(at)ghum(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Massa, Harald Armin | 2009-12-11 09:25:42 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |
| Previous Message | Willy-Bas Loos | 2009-12-11 09:06:48 | "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny |