Re: Considerable performance downgrade of v11 and 12 on Windows

Eugene Podshivalov <[email protected]> Fri, 29 Nov 2019 13:47:26 +0300

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CAEPw1JU_+Vu1GiAqyR_NwiSdWattyEGHNuMHmN4q38OLJ=BXdw@mail.gmail.com>

I don't think so. Why adding primary key shows the same downgraded
performance as well then?

пт, 29 нояб. 2019 г. в 13:37, Thomas Kellerer <[email protected]>:
>
> 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
>
>
>
>