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

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Table with large number of int columns, very slow COPY FROM
Дата
Msg-id 817fe5f2-c15e-4369-15ce-1e26f74bbbca@a-kretschmer.de
обсуждение исходный текст
Ответ на Table with large number of int columns, very slow COPY FROM  (Alex Tokarev <dwalin@dwalin.ru>)
Список 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


В списке pgsql-performance по дате отправления: