Re: WAL, xl_heap_insert and tuple oid mystry

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> On 12.04.2011 19:42, jagan wrote:
>> In general, why is OID of a tuple relegated as just another tuple
>> data, when it can replace xl_heaptid as a much more stable tuple
>> identifier.

> Possibly. On the other hand, another common complaint is that PostgreSQL 
> writes a lot of WAL, much more than other DBMSs. Adding more 
> higher-level information to WAL records would make that issue even 
> worse.

Actually, the real problem with that proposal is that it assumes that
the OID (a) exists and (b) is unique, neither of which is guaranteed.
Especially not when you consider that WAL log entries have to correctly
distinguish which MVCC version of a tuple is being modified.
        regards, tom lane