Re: [PERFORM] PostgreSQL not fully utilizing system resources?

2007-06-04 Thread Greg Smith
On Fri, 1 Jun 2007, Gregory Stewart wrote: Is our configuration flawed? For sure. The bad news is that you have a good chunk of work to do; the good news is that you should quickly see a dramatic improvement as that progresses. Anyways, watching the system processes we realized that Postg

Re: [PERFORM] PostgreSQL not fully utilizing system resources?

2007-06-04 Thread Bill Moran
"Gregory Stewart" <[EMAIL PROTECTED]> wrote: > > Hello List, > > We've been running PostgreSQL as our web application database for > almost a year and it has noticeably slowed down over last few months. Just going to go through your email and address each point inline. First off, you say nothing

[PERFORM] PostgreSQL not fully utilizing system resources?

2007-06-04 Thread Gregory Stewart
Hello List, We've been running PostgreSQL as our web application database for almost a year and it has noticeably slowed down over last few months. Our current setup and pgsql configuration looks like this: 8.1.2 on Ubuntu 4 on Opteron Dual Core with 2 GBytes RAM. This is a dedicated DB server.