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

From devik@cdi.cz
Subject Re: pgsql is 75 times faster with my new index scan
Date
Msg-id 39D1BEDC.71864914@cdi.cz
Whole thread Raw
In response to RE: pgsql is 75 times faster with my new index scan  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
> What is *true* CLUSTER ?
> 
> 'grep CLUSTER' over the latest SQL standards gives back nothing.

storing data in b-tree instead of heap for example.

> > And update *entire* heap after addition new index?!
> 
> I guess that this should be done even for limited number of
> indices' TIDs in a heap tuple ?

yep - the idea was throwed away already.


pgsql-hackers by date:

Previous
From: devik@cdi.cz
Date:
Subject: Re: pgsql is 75 times faster with my new index scan
Next
From: Philip Warner
Date:
Subject: Change of behaviour of pg_get_userbyid & pg_get_viewdef - do it?