Re: Why B-Tree suffix truncation matters

2018-07-05 Thread Peter Geoghegan
On Thu, Jul 5, 2018 at 7:17 AM, Andrey Borodin wrote: > Some years ago I've observed viable performance improvement (around 8% in > inserts and 5% in selects) of covering indexes in a series of experiments [0]. Covering indexes are definitely a closely related idea. It kind of makes sense that w

Re: Why B-Tree suffix truncation matters

2018-07-05 Thread Andrey Borodin
Hi, Peter! > 4 июля 2018 г., в 20:43, Peter Geoghegan написал(а): > > I've been working on B-Tree suffix truncation Thank you for this detailed explanation. I must admit I've been seriously confusing prefix truncation and suffix truncation before this post. Some years ago I've observed viable