| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
| Cc: | "Massa, Harald Armin" <chef(at)ghum(dot)de>, "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 15:13:40 |
| Message-ID: | 937d27e10912110713y51c1746fg9ecfbf536bff70e6@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 11, 2009 at 3:11 PM, Greg Smith <greg(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2009-12-11 15:15:38 | Re: apply text mask |
| Previous Message | Cjkalbente | 2009-12-11 15:13:32 | Re: Postgresql: daily manual tranfer |