Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Background ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 12 Topic 3995 of 4424
Post > Topic >>

Re: Background writer underemphasized ...

by gsmith@[EMAIL PROTECTED] (Greg Smith) Apr 16, 2008 at 03:55 PM

On Wed, 16 Apr 2008, Bill Moran wrote:

>> bgwriter_delay = 10000ms         # 10-10000ms between rounds
>> bgwriter_lru_maxpages = 1000     # 0-1000 max buffers written/round
> Have you watched closely under load to ensure that you're not seeing a 
> huge performance hit every 10s when the bgwriter kicks off?

bgwriter_lru_maxpages = 1000 means that any background writer pass can 
write at most 1000 pages = 8MB.  Those are buffered writes going into the 
OS cache, which it will write out at its own pace later.  That isn't going

to cause a performance hit when it happens.

That isn't the real mystery though--where's the RAID5 rant I was expecting

from you?

--
* Greg Smith gsmith@[EMAIL PROTECTED]
 http://www.gregsmith.com
Baltimore, MD

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 12 Posts in Topic:
Background writer underemphasized ...
mjy@[EMAIL PROTECTED] (M  2008-04-16 17:22:50 
Re: Background writer underemphasized ...
Chris Browne <cbbrowne  2008-04-16 13:47:59 
Re: Background writer underemphasized ...
wmoran@[EMAIL PROTECTED]   2008-04-16 14:43:35 
Re: Background writer underemphasized ...
gsmith@[EMAIL PROTECTED]   2008-04-16 15:55:51 
Re: Background writer underemphasized ...
gsmith@[EMAIL PROTECTED]   2008-04-16 15:45:22 
Re: Background writer underemphasized ...
mjy@[EMAIL PROTECTED] (M  2008-04-17 20:46:05 
Re: Background writer underemphasized ...
gsmith@[EMAIL PROTECTED]   2008-04-19 05:22:46 
Re: Background writer underemphasized ...
james@[EMAIL PROTECTED]   2008-04-19 16:06:05 
Re: Background writer underemphasized ...
gsmith@[EMAIL PROTECTED]   2008-04-19 15:29:38 
Re: Background writer underemphasized ...
james@[EMAIL PROTECTED]   2008-04-20 15:41:13 
Re: Background writer underemphasized ...
gsmith@[EMAIL PROTECTED]   2008-04-23 01:11:01 
Re: Background writer underemphasized ...
wmoran@[EMAIL PROTECTED]   2008-04-16 16:07:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:39:15 CST 2008.