Horton

Re: Table with large number of int columns, very slow COPY FROM

Andreas Kretschmer <andreas@a-kretschmer.de>

View thread View on postgr.es
From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-performance@lists.postgresql.org
Date: 2017-12-08T07:20:40Z
Lists: pgsql-hackers, pgsql-performance 

On 08.12.2017 05:21, Alex Tokarev wrote:
> I have made a minimally reproducible test case consisting of a table 
> with 848 columns

Such a high number of columns is maybe a sign of a wrong table / 
database design, why do you have such a lot of columns? How many indexes 
do you have?

Regards, Andreas

Commits

  1. Hand code string to integer conversion for performance.

  2. Deduplicate "invalid input syntax" messages for various types.