Re: Considerable performance downgrade of v11 and 12 on Windows

Thomas Kellerer <[email protected]> Fri, 29 Nov 2019 11:36:56 +0100

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[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