On Tue, Jun 15, 2021 at 12:01:00PM +0900, Michael Paquier wrote:
> On Tue, Jun 15, 2021 at 11:49:21AM +0900, Masahiko Sawada wrote:
> > On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian <br...@momjian.us> wrote:
> >> OK, but I need more information on how users will see a difference based
> >> on this commit:
>
> +1. That would be good to have in the release notes.
>
> > I think that since with this commit the server on Windows can handle a
> > file over 4GB, COPY FROM loading data from an over 4GB file and
> > pg_dump dumping a large table work now.
>
> Segment files or WAL files larger than 4GB also gain from that.
> Anything for which we may finish to do a stat() on benefits from this
> change if running on Windows. For pg_dump, a workaround in PG <= 13
> was to use --no-sync as the stat() failure came from files with a size
> larger than 4GB. That's rather sad as that means sacrifying
> durability for more usability :(
OK, I went with this text and put it in the Source Code section since it
applies to several layers of Postgres.
--
Bruce Momjian <br...@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
diff --git a/doc/src/sgml/release-14.sgml b/doc/src/sgml/release-14.sgml
index 53221ab8c1..28d0e1396b 100644
--- a/doc/src/sgml/release-14.sgml
+++ b/doc/src/sgml/release-14.sgml
@@ -3553,6 +3553,25 @@ Author: Peter Eisentraut <pe...@eisentraut.org>
<listitem>
<!--
+Author: Tom Lane <t...@sss.pgh.pa.us>
+2020-10-09 [bed90759f] Fix our Windows stat() emulation to handle file sizes >
+-->
+
+ <para>
+ Allow Windows to properly handle files larger than four gigabytes
+ (Juan José SantamarÃa Flecha)
+ </para>
+
+ <para>
+ For example this allows <link
+ linkend="sql-copy"><command>COPY,</command></link> <link
+ linkend="configure-options-misc"><acronym>WAL</acronym></link>
+ files, and relation segment files to be larger than four gigabytes.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
Author: Peter Eisentraut <pe...@eisentraut.org>
2021-01-06 [4656e3d66] Replace CLOBBER_CACHE_ALWAYS with run-time GUC
-->
