Re: Does Oracle store values in indices?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
Cc: "'Denis Perchine'" <dyp(at)perchine(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Does Oracle store values in indices?
Date: 2001-01-23 23:01:19
Message-ID: 8248.980290879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message M Carling 2001-01-24 01:45:28 [JOB] pqsql hacker needed
Previous Message Tom Lane 2001-01-23 22:43:07 Re: [PATCHES] binary operators on integers