Re: [HACKERS] bghinter process

2011-12-21 Thread Aidan Van Dyk
On Wed, Dec 21, 2011 at 1:59 PM, Alvaro Herrera wrote: > But, well, tuples that are succesfully hinted need no more hint bits. Not only do they need no more hinting, they also allow the next client-serving process that hits it avoid the clog lookup to determine the hint. a. -- Aidan Van Dyk  

Re: [HACKERS] bghinter process

2011-12-21 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mié dic 21 15:47:13 -0300 2011: > Maybe. But I think we'd need to see some test results showing that it > helps. I mean, the nice thing about our current system is that we > don't set hint bits on tuples unless we otherwise have some need to > look at them

Re: [HACKERS] bghinter process

2011-12-21 Thread Robert Haas
On Wed, Dec 21, 2011 at 1:14 PM, Kevin Grittner wrote: > Would it make sense, as suggested by Álvaro in the "CLOG contention" > thread, to have a background process to set hint bits on tuples in > dirty pages?  Processing could be loosely based around the > background writer techniques in terms of

[HACKERS] bghinter process

2011-12-21 Thread Kevin Grittner
Would it make sense, as suggested by Álvaro in the "CLOG contention" thread, to have a background process to set hint bits on tuples in dirty pages? Processing could be loosely based around the background writer techniques in terms of sweeping through the cache, but it would only look at dirty pag