Re: global temporary tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: global temporary tables
Дата
Msg-id 7079.1272222143@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: global temporary tables  (Jim Nasby <decibel@decibel.org>)
Список pgsql-hackers
Jim Nasby <decibel@decibel.org> writes:
> On Apr 24, 2010, at 10:02 PM, Tom Lane wrote:
>> Yeah.  I think we also use RelFileNode as a hash tag in places, and
>> so adding a bool to it would be problematic for a couple of reasons:
>> possibly uninitialized pad bytes, and uselessly incorporating more bytes
>> into the hash calculation.

> Do we need to hash it that frequently?

Every buffer access, for instance.

> Do we insert tons of them into WAL?

Yes; the vast majority of WAL records contain one.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: proposal - structured funcid and lineno as new fields in error message
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: testing HS/SR - 1 vs 2 performance