Re: Considerable performance downgrade of v11 and 12 on Windows

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Considerable performance downgrade of v11 and 12 on Windows
Дата
Msg-id 1d19c0ec-a551-67ee-5f15-ff72bf7e7b40@gmx.net
обсуждение исходный текст
Ответ на Considerable performance downgrade of v11 and 12 on Windows  (Eugene Podshivalov <yaugenka@gmail.com>)
Ответы Re: Considerable performance downgrade of v11 and 12 on Windows  (Eugene Podshivalov <yaugenka@gmail.com>)
Список pgsql-performance
Eugene Podshivalov schrieb am 29.11.2019 um 11:04:
> Imported ways data from a file and added a primary key.
> 
> SET synchronous_commit TO OFF;
> COPY ways FROM 'E:\ways.txt';

> ...
> COPY ways FROM PROGRAM 'cmd /c "type E:\ways.txt"';

Those two commands are not doing the same thing - the piping through the TYPE command is most probably eating all the
performance





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

Предыдущее
От: Eugene Podshivalov
Дата:
Сообщение: Considerable performance downgrade of v11 and 12 on Windows
Следующее
От: Eugene Podshivalov
Дата:
Сообщение: Re: Considerable performance downgrade of v11 and 12 on Windows