RE: pgsql is 75 times faster with my new index scan

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Hannu Krosing'" <hannu(at)tm(dot)ee>, devik(at)cdi(dot)cz
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: RE: pgsql is 75 times faster with my new index scan
Date: 2000-09-26 19:07:41
Message-ID: 8F4C99C66D04D4118F580090272A7A23018D0D@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-09-26 19:09:29 RE: pgsql is 75 times faster with my new index scan
Previous Message Lamar Owen 2000-09-26 18:08:45 Re: [BUGS] 7.0.2 source rpm failed to compile