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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Table with large number of int columns, very slow COPY FROM
From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>
Date: Fri, 8 Dec 2017 08:20:40 +0100
In-reply-to: <D64F5359.2993D%dwalin@dwalin.ru>
References: <D64F5359.2993D%dwalin@dwalin.ru>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0



On 08.12.2017 05:21, Alex Tokarev wrote:

I have made a minimally reproducible test case consisting of a tablewith 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 indexesdo you have?


Regards, Andreas

References:
- Table with large number of int columns, very slow COPY FROM
  - From: Alex Tokarev

Prev by Date: Re: Setting effective_io_concurrency in VM?
Next by Date: Re: Learning EXPLAIN
Previous by thread: Table with large number of int columns, very slow COPY FROM
Next by thread: Re: Table with large number of int columns, very slow COPY FROM
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux