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

От

Dave Page

Тема

Дата

11 декабря 2009 г. в 05:08:22

Msg-id

937d27e10912110108x3493359fj24c11aac80ed24f3@mail.gmail.com

обсуждение

Ответ на

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. (Massa, Harald Armin)

Список

pgsql-general

Дерево обсуждения

Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. <A.Bhattacharya@sungard.com> 11 декабря 2009 г. в 02:56:42

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. "A. Kretschmer" <andreas.kretschmer@schollglas.com> 11 декабря 2009 г. в 03:21:52

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. John R Pierce <pierce@hogranch.com> 11 декабря 2009 г. в 03:15:36

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. "Massa, Harald Armin" <chef@ghum.de> 11 декабря 2009 г. в 05:02:35

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Dave Page <dpage@pgadmin.org> 11 декабря 2009 г. в 05:08:22

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Greg Smith <greg@2ndquadrant.com> 11 декабря 2009 г. в 11:11:13

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Dave Page <dpage@pgadmin.org> 11 декабря 2009 г. в 11:21:55

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. "Massa, Harald Armin" <chef@ghum.de> 11 декабря 2009 г. в 12:39:21

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. "Massa, Harald Armin" <chef@ghum.de> 11 декабря 2009 г. в 05:25:51

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Peter Geoghegan <peter.geoghegan86@gmail.com> 11 декабря 2009 г. в 08:53:09

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Craig Ringer <craig@postnewspapers.com.au> 11 декабря 2009 г. в 10:43:02

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. John R Pierce <pierce@hogranch.com> 11 декабря 2009 г. в 14:50:10

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. Peter Geoghegan <peter.geoghegan86@gmail.com> 11 декабря 2009 г. в 22:18:01

On Fri, Dec 11, 2009 at 9:02 AM, Massa, Harald Armin  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

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

Предыдущее

От: Willy-Bas Loos

Дата: 11 декабря 2009 г. в 05:07:05

Сообщение: "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny

Следующее

От: Massa, Harald Armin

Дата: 11 декабря 2009 г. в 05:25:51

Сообщение: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.