Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error” - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”
Date
Msg-id 20191120161909.edfjorf7rnvrox6q@development
Whole thread Raw
In response to Re: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2copy table from ‘large 2GB csv’report “Unknown error”  ("leiyanliang@highgo.com" <leiyanliang@highgo.com>)
List pgsql-bugs
On Wed, Nov 20, 2019 at 09:42:49PM +0800, leiyanliang@highgo.com wrote:
>Thank you for reply.
>
>I do not think the root cause of this problem is about privilege,and this windows machine is my test machine, only I
haveaccess to this machine.
 
>
>I think this problem is a bug,there are two evidences:
>
>The first evidence :
>
>postgres=# select version();
>                          version
>------------------------------------------------------------
> PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit
>(1 行记录)
>
>
>时间:0.280 ms
>postgres=#
>postgres=#
>postgres=# copy github_events from  'd:\events.csv' csv;   ----->>> d:\events.csv( about 316,302,020 Bytes) can copy
succussfully!!
>COPY 126245
>时间:19574.819 ms (00:19.575)
>postgres=# \q
>

Ah, I haven't noticed the information about file size in the first post,
as it was buried at the very end :-(

In that case, I think Tom is right it's likely the same issue as [1],
although that starts with a report about issues with 4GB. Maybe that's
due to using different windows version 2008 R2 vs. 2012 R2, though.

It'd be good if you could test the latest patch [2] in that thread.
You'll need to build PostgreSQL on Windows, though - I don't have much
experience with that, but there are wiki pages about doing that either
using Visual Studio [3] or mingw [4].


regards


[1] https://www.postgresql.org/message-id/15858-9572469fd3b73263%40postgresql.org

[2] https://www.postgresql.org/message-id/attachment/103789/0001-WIP-support-for-large-files-on-Win32-v4.patch

[3] https://wiki.postgresql.org/wiki/Working_With_VisualStudio

[4] https://wiki.postgresql.org/wiki/Building_With_MinGW

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16127: PostgreSQL 12.1 on Windows 2008 R2 copy table from ‘large 2GB csv’report “iso-8859-1 error”
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE fails when changing column type due to index with bit_ops opclass