Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux