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

From Dave Page
Subject Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date
Msg-id 937d27e10912110713y51c1746fg9ecfbf536bff70e6@mail.gmail.com
Whole thread Raw
In response to Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
On Fri, Dec 11, 2009 at 3:11 PM, Greg Smith <greg@2ndquadrant.com> wrote:

> Dave is talking about Greg Stark here, lest anyone credit me for something I

Err, yes indeed. Sorry. Keep forgetting that postgresql.org is the
only place in the world with more Gregs than Daves...

> wasn't involved in.  I just updated the shared_buffers section of "Tuning
> Your PostgreSQL Server" to reflect Dave's comments and to generally clean up
> the Windows suggestions here.  I recall seeing some comments in the past
> that suggested earlier systems started to fall off at closer to 64MB rather
> than 128MB, tweaked the wording there accordingly.  8MB working out best is
> really unexpected though; I'd like to know what you were doing where *that*
> was the optimal setting.

Thanks.


--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump and ON DELETE CASCADE problem
Next
From: Pavel Stehule
Date:
Subject: Re: PIVOT tables and crosstab