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

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: pgsql is 75 times faster with my new index scan
Дата
Msg-id 39D1968E.C1B68213@tm.ee
обсуждение исходный текст
Ответ на RE: pgsql is 75 times faster with my new index scan  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-hackers
"Mikheev, Vadim" wrote:
> 
> Why not implement *true* CLUSTER?
> With cluster, all heap tuples will be in cluster index.
> 

What is *true* CLUSTER ?

'grep CLUSTER' over the latest SQL standards gives back nothing.


> > > 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?!

I guess that this should be done even for limited number of 
indices' TIDs in a heap tuple ?

--------------
Hannu


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: use of / in ~ vs. ~*
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: Re: function crashes backend