Re: Bulk Insert into PostgreSQL - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Bulk Insert into PostgreSQL
Date
Msg-id CAH2-Wznh=ULMY=SHNBidF5h0V+b+NVscSOyWm1OdFCF+iXDG4A@mail.gmail.com
Whole thread Raw
In response to Re: Bulk Insert into PostgreSQL  (Srinivas Karthik V <skarthikv.iitb@gmail.com>)
Responses Re: Bulk Insert into PostgreSQL  (Srinivas Karthik V <skarthikv.iitb@gmail.com>)
List pgsql-hackers
On Tue, Jul 3, 2018 at 4:34 PM, Srinivas Karthik V
<skarthikv.iitb@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_zzHxmw@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


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Why B-Tree suffix truncation matters
Next
From: Alvaro Herrera
Date:
Subject: Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions