Re: Fast insertion indexes: why no developments - Mailing list pgsql-hackers

From Leonardo Francalanci
Subject Re: Fast insertion indexes: why no developments
Date
Msg-id 1383062020.34721.YahooMailNeo@web172603.mail.ir2.yahoo.com
Whole thread Raw
In response to Re: Fast insertion indexes: why no developments  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> They should, in theory, be faster than btrees -- O(1) not O(log N) page
> fetches per lookup.  In practice they don't seem to be faster, and
> nobody's bothered to find out exactly why.  Again, this isn't a terribly
> encouraging precedent for implementing some other index type that's
> supposed to (sometimes) be faster than btrees.

Yes, I understand. Which is also why I was curious to know if the "claims" those papers (and the databases using them)
makewere real... 

Thank you everybody for your replies.

Leonardo



pgsql-hackers by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: Fast insertion indexes: why no developments
Next
From: David Johnston
Date:
Subject: Re: How should row-security affects ON UPDATE RESTRICT / CASCADE ?