bg-writer queries regarding ( [Testperf-general] BufferSync and bgwriter )

From: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: bg-writer queries regarding ( [Testperf-general] BufferSync and bgwriter )
Date: 2005-05-12 14:58:41
Message-ID: 20050512145841.25430.qmail@web51005.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

browsing through the archives i came across this::
http://pgfoundry.org/pipermail/testperf-general/2004-December/000080.html

which seems to be of the time when bgwriter was in development stage....

i need some clarifications......

is there a separate list of dirty buffers and clean buffers.....

if there is then its ok.... bgwriter will start from LRU side and keep writing till it has written either bgwriter_maxpages or bgwriter_percent....

now if there is no separate list for dirty buffers.... bgwriter will scan the entire list to check how many are there.... which it needs for bgwriter_percent... and then write bgwriter_maxpages or bgwriter_percent pages... which ever is less....

also how should we decide wht should be the bgwriter settings.... is there a way to determine how many dirty buffers are there currently...

should i check the io usage...and if its free increase bgwriter and if its full reduce it.... which tool should i use for determining the io-usage....

regards
himanshu


---------------------------------
Yahoo! Mail
Stay connected, organized, and protected. Take the tour

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-05-12 15:11:57 Re: Need input on postgres used for phpBB
Previous Message Oleg Bartunov 2005-05-12 14:54:02 Re: Tsearch2 lexeme position