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

Поиск
Список
Период
Сортировка
От Massa, Harald Armin
Тема Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Дата
Msg-id e3e180dc0912110102j2d52f03dtb1fd9f76756937ae@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (<A.Bhattacharya@sungard.com>)
Ответы Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Dave Page <dpage@pgadmin.org>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Следующее
От: Willy-Bas Loos
Дата:
Сообщение: "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny