Re: Considerable performance downgrade of v11 and 12 on Windows - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Considerable performance downgrade of v11 and 12 on Windows
Date
Msg-id 1d19c0ec-a551-67ee-5f15-ff72bf7e7b40@gmx.net
Whole thread Raw
In response to Considerable performance downgrade of v11 and 12 on Windows  (Eugene Podshivalov <yaugenka@gmail.com>)
Responses Re: Considerable performance downgrade of v11 and 12 on Windows  (Eugene Podshivalov <yaugenka@gmail.com>)
List 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 by date:

Previous
From: Eugene Podshivalov
Date:
Subject: Considerable performance downgrade of v11 and 12 on Windows
Next
From: Eugene Podshivalov
Date:
Subject: Re: Considerable performance downgrade of v11 and 12 on Windows