I don't think so. Why adding primary key shows the same downgraded performance as well then?
пт, 29 нояб. 2019 г. в 13:37, Thomas Kellerer <spam_ea...@gmx.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 > > > >
