Re: limiting hint bit I/O
От | Tom Lane |
---|---|
Тема | Re: limiting hint bit I/O |
Дата | |
Msg-id | 8493.1295028363@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: limiting hint bit I/O (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: limiting hint bit I/O
|
Список | pgsql-hackers |
Robert Haas <robertmhaas@gmail.com> writes: > On Fri, Jan 14, 2011 at 12:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Moreover this whole business of not treating hint-bit setting as >> a page-dirtying operation is completely experimental/unproven IMO, so it >> would be better to keep the patch footprint as small as possible. > I have some concerns about that proposal, but it might be the right > way to go. Before we get too far off into the weeds, though, let's > back up and talk about something more fundamental: this seems to be > speeding up the first run by 6x at the expense of slowing down many > subsequent runs by 10-15%. Does that make this whole idea dead on > arrival? Well, it reinforces my opinion that it's experimental ;-). But "first run" of what, exactly? And are you sure you're taking a wholistic view of the costs/benefits? regards, tom lane
В списке pgsql-hackers по дате отправления: