Horton
Menu

Re: global temporary tables

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim Nasby <decibel@decibel.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org
Date: 2010-04-25T19:02:23Z
Lists: 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