Hannu Krosing wrote:
> > TODO:
> > - add HeapTupleHeaderData into each IndexTupleData
> > - change code to reflect above
> > - when deleting-updating heap then also update tuples'
> > HeapTupleHeaderData in indices
> I doubt everyone would like trading query speed for insert/update
> speed plus index size
> Perhaps this could be implemented as a special type of index which
> you must explicitly specify at create time ?
> > The last step could be done in two ways. First by limiting
> > number of indices for one table we can store coresponding
> > indices' TIDs in each heap tuple. The update is then simple
> > taking one disk write.
> Why limit it ? One could just save an tid array in each tuple .
Indice's TIDs are transient.
Isn't it useless to store indice's TIDs ?
In response to
pgsql-hackers by date
|Next:||From: devik||Date: 2000-09-26 11:13:40|
|Subject: Re: pgsql is 75 times faster with my new index scan|
|Previous:||From: Hannu Krosing||Date: 2000-09-26 10:35:24|
|Subject: Re: Case sensitive field names|