Re: Fast insertion indexes: why no developments

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fast insertion indexes: why no developments
Date: 2013-10-30 07:55:26
Message-ID: 1383119726.18130.YahooMailNeo@web172605.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2013-10-30 08:51:57 Re: appendStringInfo vs appendStringInfoString
Previous Message Abhijit Menon-Sen 2013-10-30 07:28:33 Re: [PATCH] Use MAP_HUGETLB where supported (v3)