Re: [PERFORM] Occasional Slow Commit

2008-10-31 Thread David Rees
(Resending this, the first one got bounced by mail.postgresql.org) On Wed, Oct 29, 2008 at 3:30 PM, David Rees <[EMAIL PROTECTED]> wrote: > On Wed, Oct 29, 2008 at 6:26 AM, Greg Smith <[EMAIL PROTECTED]> wrote: >> What you should do first is confirm >> whether or not the slow commits line up with

Re: [PERFORM] Index usage problem on 8.3.3

2008-10-31 Thread Jeff Frost
On Fri, 31 Oct 2008, Gregory Stark wrote: Tom Lane <[EMAIL PROTECTED]> writes: Jeff Frost <[EMAIL PROTECTED]> writes: Tom Lane wrote: Huh. That does sound like it's a version-to-version difference. There's nothing in the CVS log that seems related though. Are you willing to post your test

Re: [PERFORM] Configuring for maximum memory usage

2008-10-31 Thread Scott Carey
On Thu, Oct 30, 2008 at 2:06 PM, Christiaan Willemsen < [EMAIL PROTECTED]> wrote: > Thanks guys, > Lots of info here that I didn't know about! Since I have one of the latest > Opensolaris builds, I guess the write throttle feature is already in there. > Sadly, the blog doesn't say what build has i

Re: [PERFORM] Index usage problem on 8.3.3

2008-10-31 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Jeff Frost <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> Huh. That does sound like it's a version-to-version difference. >>> There's nothing in the CVS log that seems related though. Are you >>> willing to post your test case? >>> >> It's a customer D

Re: [PERFORM] CPU utilization vs. IO wait, shared buffers?

2008-10-31 Thread znmeb
Quoting Oliver Johnson <[EMAIL PROTECTED]>: Hi everybody, I am running a bake/load test and I am seeing sudden, daily shifts from CPU utilization to IO wait. The load harness has been running for 3 weeks and should be putting a uniform load on the application. The application processes data on