Re: Fast insertion indexes: why no developments

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: Fast insertion indexes: why no developments
Дата
Msg-id 1383119726.18130.YahooMailNeo@web172605.mail.ir2.yahoo.com
обсуждение исходный текст
Ответ на Re: Fast insertion indexes: why no developments  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Fast insertion indexes: why no developments  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
> Hmm, you realise Alvaro is working on MinMax indexes in this release?
> They are very efficient with regard to index inserts and specially
> designed for use on large tables.
>
> Prior work by Heikki on Grouped Item Tuples was a way of reducing the
> size of indexes, yet still allowing uniqueness checks. That is
> implemented in SQLServer already and is very useful.


Reading the implementation of those features, I don't think they can help in the cases handled by the index types I
mentioned(insertions of random values in big tables). 




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

Предыдущее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: [PATCH] Use MAP_HUGETLB where supported (v3)
Следующее
От: David Rowley
Дата:
Сообщение: Re: appendStringInfo vs appendStringInfoString