memory layouts for binary search in nbtree - Mailing list pgsql-hackers

From Andres Freund
Subject memory layouts for binary search in nbtree
Date
Msg-id 20160518132537.grcicnutjbl2iwpe@alap3.anarazel.de
Whole thread Raw
Responses Re: memory layouts for binary search in nbtree  (Simon Riggs <simon@2ndQuadrant.com>)
Re: memory layouts for binary search in nbtree  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
Hi,

currently we IIRC use linearly sorted datums for the search in
individual btree nodes.  Not surprisingly that's often one of the
dominant entries in profiles. We could probably improve upon that by
using an order more optimized for efficient binary search.

See e.g.  http://cglab.ca/~morin/misc/arraylayout/ for benchmarks
showing benefits.

Andres



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Reviewing freeze map code
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Reviewing freeze map code