Re: Considerable performance downgrade of v11 and 12 on Windows

Поиск
Список
Период
Сортировка
От Eugene Podshivalov
Тема Re: Considerable performance downgrade of v11 and 12 on Windows
Дата
Msg-id CAEPw1JU_+Vu1GiAqyR_NwiSdWattyEGHNuMHmN4q38OLJ=BXdw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Considerable performance downgrade of v11 and 12 on Windows  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-performance
I don't think so. Why adding primary key shows the same downgraded
performance as well then?

пт, 29 нояб. 2019 г. в 13:37, Thomas Kellerer <spam_eater@gmx.net>:
>
> 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 по дате отправления:

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