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

Поиск
Список
Период
Сортировка
От devik@cdi.cz
Тема Re: pgsql is 75 times faster with my new index scan
Дата
Msg-id 39D084E4.80383884@cdi.cz
обсуждение исходный текст
Ответ на pgsql is 75 times faster with my new index scan  (devik@cdi.cz)
Список 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 .

because when you add new index you had to rescan whole
heap and grow the tid array ..

> Indice's TIDs are transient.
> Isn't it useless to store indice's TIDs ?

but yes Hiroshi is right. Index TID is transient. I first looked
into pg sources two weeks ago so I have still holes in my knowledge.
So that only solution is to traverse it ..




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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Reimplementing permission checks for rules
Следующее
От: devik@cdi.cz
Дата:
Сообщение: Re: pgsql is 75 times faster with my new index scan