Subject: Re: Considerable performance downgrade of v11 and 12 on Windows
To: pgsql-performance@lists.postgresql.org
References: 
 <CAEPw1JWqO+Fi5J+bKek+OTh81fyMZV=d5L22Dg9KNxBh7tH_UA@mail.gmail.com>
From: Thomas Kellerer <spam_eater@gmx.net>
Message-ID: <1d19c0ec-a551-67ee-5f15-ff72bf7e7b40@gmx.net>
Date: Fri, 29 Nov 2019 11:36:56 +0100
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CAEPw1JWqO+Fi5J+bKek+OTh81fyMZV=d5L22Dg9KNxBh7tH_UA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: 7bit
Precedence: bulk

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