Re: limiting hint bit I/O
| От | Tom Lane |
|---|---|
| Тема | Re: limiting hint bit I/O |
| Дата | |
| Msg-id | 9459.1295032176@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: 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 <robertmhaas@gmail.com> writes:
> On Fri, Jan 14, 2011 at 1:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Um, yeah, I think you're having a problem keeping all the ideas straight
>> ;-). �The argument about forensics has to do with how soon we're willing
>> to freeze tuples, ie replace the XID with a constant. �Not about hint
>> bits.
> Those things are related, though. Freezing sooner could be viewed as
> an alternative to hint bits.
Freezing sooner isn't likely to reduce I/O compared to hint bits. What
that does is create I/O that you *have* to execute ... both in the pages
themselves, and in WAL.
regards, tom lane
В списке pgsql-hackers по дате отправления: