RE: Use of index in 7.0 vs 6.5

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Use of index in 7.0 vs 6.5
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A23018C02@SECTORBASE1
обсуждение исходный текст
Ответ на Use of index in 7.0 vs 6.5  (Ryan Bradetich <ryan_bradetich@hp.com>)
Список pgsql-sql
> > Oracle has index keys distribution page... And we have near empty
> > meta-page for each index AM... And backend reads this page for
> > each insert...
> 
> That certainly would make sense.  We have hesitated to gather more
> statistics because of the time involved.  Fuller statistics 
> on just the
> indexed columns could be a big win and be done fairly quickly because
> the rows are already sorted in the index.

So, add new item to TODO -:)
(I'm sure that I've told about index keys distribution page already -
I become tired to say about the same more and more -:))

Vadim


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Use of index in 7.0 vs 6.5
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Use of index in 7.0 vs 6.5