Re: limiting hint bit I/O
От | Kevin Grittner |
---|---|
Тема | Re: limiting hint bit I/O |
Дата | |
Msg-id | 4D331EBC0200002500039680@gw.wicourts.gov обсуждение исходный текст |
Ответ на | limiting hint bit I/O (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: limiting hint bit I/O
Re: limiting hint bit I/O |
Список | 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 по дате отправления: