Re: Long Running Commits - Not Checkpoints

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Long Running Commits - Not Checkpoints
Date: 2007-09-13 17:07:19
Message-ID: 20070913170719.GC1716@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Brad Nicholson wrote:
> On Thu, 2007-09-13 at 12:19 -0400, Brad Nicholson wrote:
> > On Thu, 2007-09-13 at 12:12 -0400, Greg Smith wrote:
> > > On Thu, 13 Sep 2007, Brad Nicholson wrote:
> >
> > > I'd be curious to see how you've got your background writer configured to
> > > see if it matches situations like this I've seen in the past. The
> > > parameters controlling the all scan are the ones you'd might consider
> > > turning down, definately the percentage and possibly the maxpages as well.
> >
> >
> > bgwriter_delay = 50 # 10-10000 milliseconds between
> > rounds
> > bgwriter_lru_percent = 20.0 # 0-100% of LRU buffers
> > scanned/round
> > bgwriter_lru_maxpages = 300 # 0-1000 buffers max
> > written/round
> > bgwriter_all_percent = 20 # 0-100% of all buffers
> > scanned/round
> > bgwriter_all_maxpages = 600 # 0-1000 buffers max
> > written/round
>
> I should add, there are 6 back ends running on this disk array
> (different servers and different data partitions) with these bgwriter
> settings.

Maybe it is running deferred triggers or something?

--
Alvaro Herrera http://www.advogato.org/person/alvherre
"I suspect most samba developers are already technically insane...
Of course, since many of them are Australians, you can't tell." (L. Torvalds)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-09-13 17:46:42 Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Previous Message Brad Nicholson 2007-09-13 16:52:21 Re: Long Running Commits - Not Checkpoints