RE: pgsql is 75 times faster with my new index scan - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: pgsql is 75 times faster with my new index scan
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018D0D@SECTORBASE1
Whole thread Raw
In response to pgsql is 75 times faster with my new index scan  (devik@cdi.cz)
List pgsql-hackers
> > 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 .

And update *entire* heap after addition new index?!

Vadim


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [BUGS] 7.0.2 source rpm failed to compile
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: pgsql is 75 times faster with my new index scan