| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Srinivas Karthik V <skarthikv(dot)iitb(at)gmail(dot)com> |
| Cc: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Don Seiler <don(at)seiler(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Subject: | Re: Bulk Insert into PostgreSQL |
| Date: | 2018-07-04 16:57:05 |
| Message-ID: | CAH2-Wznh=ULMY=SHNBidF5h0V+b+NVscSOyWm1OdFCF+iXDG4A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jul 3, 2018 at 4:34 PM, Srinivas Karthik V
<skarthikv(dot)iitb(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-07-04 17:15:19 | Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions |
| Previous Message | Peter Geoghegan | 2018-07-04 16:43:53 | Why B-Tree suffix truncation matters |