Search Postgresql Archives

Bgwriter--- BufferSync() and StrategyStatsDump()

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

 



wht StrategyStatsDump prints is
ARC clean buffers at LRU of T1 and T2....
now lets say i have a dirty buffer at position 31st
from LRU and the next one is at 3500th...

in cases like this... t1_clean and t2_clean are of no
use....

a better option would be to have a function like
StrategyDirtyBufferList() which will scan till it
finds max_buffers dirty buffers or end of the list...
but a function like this would have a high
overhead....

so a even better method is to print the no. of total
buffers it had to scan each time bgwriter wrote... 

something like.. to find 100 dirty buffers it had to
scan 15000 buffers....

this would greatly help ppl in determining the
appropriate value of bgwriter parameters.... it would
require a simple patch to written which will add two
else statements in StrategyDirtyBufferList() and
returning a struct instead of int...
also a line in function BufferSync()=>
elog(DEBUG1,......

i would really love to see something like this to be
added to postgres... as then we wont have to spend one
whole day trying to determine bgwriter values and
finding in the end there is nothing much....

if there is one... plz tell...(i have already used
iowait time... but its results are not really
encouraging)...

Regards
Himanshu 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[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