Postgres Pro
Downloads
Home   >   mailing lists

Re: Large tables being split at 1GB boundary - Mailing list pgsql-novice

From Tom Lane
Subject Re: Large tables being split at 1GB boundary
Date
Msg-id 19550.1022023667@sss.pgh.pa.us
Whole thread Raw
In response to Large tables being split at 1GB boundary  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-novice
Tree view 
Ron Johnson <ron.l.johnson@cox.net> writes:
> what is the reason for splitting filenodes at the 1GB mark?
> Why not 2GB (2^31).

Some platforms fail on files >= 2GB.  Maybe it's only > 2GB,
or maybe there is funny boundary behavior.  We didn't see any
point in taking a risk.

            regards, tom lane

pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: Better way to bulk-load millions of CSV records into postgres?
Next
From: Josh Berkus
Date:
Subject: Re: Better way to bulk-load millions of CSV records into postgres?