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

From: devik(at)cdi(dot)cz
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql is 75 times faster with my new index scan
Date: 2000-09-27 09:33:16
Message-ID: 39D1BEDC.71864914@cdi.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-09-27 10:26:18 There's the rub... (a meta note)
Previous Message Louis-David Mitterrand 2000-09-27 08:13:15 Re: function crashes backend