Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group