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
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 |