| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jim Nasby <decibel(at)decibel(dot)org> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: global temporary tables |
| Date: | 2010-04-25 19:02:23 |
| Message-ID: | 7079.1272222143@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jim Nasby <decibel(at)decibel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-04-25 19:07:28 | Re: testing HS/SR - 1 vs 2 performance |
| Previous Message | Tom Lane | 2010-04-25 18:55:02 | Re: testing HS/SR - 1 vs 2 performance |