FAQ

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 currently the main focus is to check in which cases this optimization can give benefit.
   Robert had ran tests for quite a number of cases where it doesn't show any significant gain.
   I am also trying with various configurations to see if it gives any benefit.
   Robert has given some suggestions to change the way currently new function is getting called,
   I will try it 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 for tests 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.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 13 of 37 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMay 14, '13 at 1:45p
activeAug 6, '13 at 6:19a
posts37
users7
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase