Re: limiting hint bit I/O - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: limiting hint bit I/O
Date
Msg-id 4D331EBC0200002500039680@gw.wicourts.gov
Whole thread Raw
In response to limiting hint bit I/O  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: limiting hint bit I/O  (Robert Haas <robertmhaas@gmail.com>)
Re: limiting hint bit I/O  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Robert Haas  wrote:
> a quick-and-dirty attempt to limit the amount of I/O caused by hint
> bits. I'm still very interested in knowing what people think about
> that.
I found the elimination of the response-time spike promising.  I
don't think I've seen enough data yet to feel comfortable endorsing
it, though.  I guess the question in my head is: how much of the
lingering performance hit was due to having to go to clog and how
much was due to competition with the deferred writes?  If much of it
is due to repeated recalculation of visibility based on clog info, I
think there would need to be some way to limit how many times that
happened before the hint bits were saved.
-Kevin


pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: Patch to add a primary key using an existing index
Next
From: Marti Raudsepp
Date:
Subject: Re: auto-sizing wal_buffers