Re: Indexing - comparison of tree structures - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Indexing - comparison of tree structures
Date
Msg-id CADUqk8XH=u9n9N1ar3VUrnfGZ-G=SP1daVxD7aOoE6bkcsMhGA@mail.gmail.com
Whole thread Raw
In response to Indexing - comparison of tree structures  (Sascha Kuhl <yogidabanli@gmail.com>)
List pgsql-hackers
T-tree (and variants) are index types commonly associated with in-memory database management systems and rarely, if-ever, used with on-disk databases. There has been a lot of research in regard to more modern cache conscious/oblivious b-trees that perform equally or better than t-tree. What’s the use-case?

On Fri, May 24, 2019 at 5:38 AM Sascha Kuhl <yogidabanli@gmail.com> wrote:
Hi,

I compared two data structures realistically by time, after estimating big O. T-tree outperforms b-tree, which is commonly used, for a medium size table. Lehmann and Carey showed the same, earlier.

Can you improve indexing by this?

Understandably

Sascha Kuhl
--
Jonah H. Harris

pgsql-hackers by date:

Previous
From: Ashwin Agrawal
Date:
Subject: Confusing error message for REINDEX TABLE CONCURRENTLY
Next
From: sharon clark
Date:
Subject: GSoD Introductory Resources and Tutorial Projects