In response to Greg Smith <[EMAIL PROTECTED]>: > 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?
Oh crap ... he _is_ using RAID-5! I completely missed an opportunity to rant! blah blah blah ... RAID-5 == evile, etc ... -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
