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

Поиск
Список
Период
Сортировка
От Himanshu Baweja
Тема bg-writer queries regarding ( [Testperf-general] BufferSync and bgwriter )
Дата
Msg-id 20050512145841.25430.qmail@web51005.mail.yahoo.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: Tsearch2 lexeme position
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Need input on postgres used for phpBB