Re: Considerable performance downgrade of v11 and 12 on Windows

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Considerable performance downgrade of v11 and 12 on Windows
Date: 2019-11-29 10:36:56
Message-ID: 1d19c0ec-a551-67ee-5f15-ff72bf7e7b40@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Eugene Podshivalov 2019-11-29 10:47:26 Re: Considerable performance downgrade of v11 and 12 on Windows
Previous Message Eugene Podshivalov 2019-11-29 10:04:37 Considerable performance downgrade of v11 and 12 on Windows