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

From Himanshu Baweja
Subject bg-writer queries regarding ( [Testperf-general] BufferSync and bgwriter )
Date
Msg-id 20050512145841.25430.qmail@web51005.mail.yahoo.com
Whole thread Raw
List pgsql-general
browsing through the archives i came across this::
 
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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Tsearch2 lexeme position
Next
From: Scott Marlowe
Date:
Subject: Re: Need input on postgres used for phpBB