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  (Robert Haas <robertmhaas@gmail.com>)
Re: limiting hint bit I/O  (Jim Nasby <jim@nasby.net>)
Список 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 по дате отправления:

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: Patch to add a primary key using an existing index
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: auto-sizing wal_buffers