Re: Considerable performance downgrade of v11 and 12 on Windows

From: Eugene Podshivalov <yaugenka(at)gmail(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Considerable performance downgrade of v11 and 12 on Windows
Date: 2019-11-29 10:47:26
Message-ID: CAEPw1JU_+Vu1GiAqyR_NwiSdWattyEGHNuMHmN4q38OLJ=BXdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

пт, 29 нояб. 2019 г. в 13:37, Thomas Kellerer <spam_eater(at)gmx(dot)net>:
>
> 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

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2019-11-29 12:04:49 Re: Considerable performance downgrade of v11 and 12 on Windows
Previous Message Thomas Kellerer 2019-11-29 10:36:56 Re: Considerable performance downgrade of v11 and 12 on Windows