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)
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 |