On Tue, Jul 3, 2018 at 4:34 PM, Srinivas Karthik V <skarthikv.i...@gmail.com> wrote: > @Peter: I was indexing the primary key of all the tables in tpc-ds. Some of > the fact tables has multiple columns as part of the primary key. Also, most > of them are numeric type.
Please see my mail to -hackers on suffix truncation: https://postgr.es/m/CAH2-Wzn5XbCzk6u0GL+uPnCp1tbrp2pJHJ=3byt4yq0_zzh...@mail.gmail.com Perhaps this is related in some way, since in both cases we're talking about a composite index on varlena-type columns, where the types have expensive comparisons. -- Peter Geoghegan
