Re: Does Oracle store values in indices? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Does Oracle store values in indices?
Date
Msg-id 8248.980290879@sss.pgh.pa.us
Whole thread Raw
In response to RE: Does Oracle store values in indices?  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> We could add transaction data to index tuples but this would increase
> their size by ~ 16bytes.

The increased space is the least of the drawbacks.  Consider also the
time needed to maintain N copies of a tuple's commit status instead of
one.  Even finding the N copies would cost a lot more than the single
disk transfer involved now ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] binary operators on integers
Next
From: Alex Pilosov
Date:
Subject: Re: pg_shadow.usecatupd attribute