Postgres Pro
Downloads
Home   >   mailing lists

Re: Table with large number of int columns, very slow COPY FROM - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: Table with large number of int columns, very slow COPY FROM
Date
Msg-id 817fe5f2-c15e-4369-15ce-1e26f74bbbca@a-kretschmer.de
Whole thread Raw
In response to Table with large number of int columns, very slow COPY FROM  (Alex Tokarev <dwalin@dwalin.ru>)
List pgsql-performance
Tree view 

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

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Setting effective_io_concurrency in VM?
Next
From: Guillaume Lelarge
Date:
Subject: Re: Learning EXPLAIN