On Friday, May 24, 2013 8:22 PM Jim Nasby wrote:
On 5/14/13 8:42 AM, Amit Kapila wrote:
>> In the attached patch, bgwriter/checkpointer moves unused (usage_count =0 && refcount = 0) buffer’s to end of
freelist.I have implemented a new API StrategyMoveBufferToFreeListEnd() to
>>
>> move buffer’s to end of freelist.
>>
> Instead of a separate function, would it be better to add an argument to StrategyFreeBuffer?
Yes, it could be done with a parameter which will decide whether to put buffer at head or tail in freelist. However
currentlythe main focus is to check in which cases this optimization can give benefit. Robert had ran tests for quite a
numberof cases where it doesn't show any significant gain. I am also trying with various configurations to see if it
givesany benefit. Robert has given some suggestions to change the way currently new function is getting called, I will
tryit and update the results of same.
I am not very sure that default pgbench is a good test scenario to test this optimization. If you have any suggestions
fortests where it can show benefit, that would be a great input.
> ISTM this is similar to the other strategy stuff in the buffer manager, so perhaps it should mirror that...
With Regards,
Amit Kapila.