Re: [HACKERS] Fix for large file support (nonsegment mode support) - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] Fix for large file support (nonsegment mode support)
Date
Msg-id 22898.1205252457@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Fix for large file support (nonsegment mode support)  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: [HACKERS] Fix for large file support (nonsegment mode support)
Re: [HACKERS] Fix for large file support (nonsegment mode support)
List pgsql-patches
Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Tom Lane napsal(a):
>> These examples suggest that maybe what we want is not so much a "no
>> segments ever" mode as a segment size larger than 1GB.

> PS: ZFS is happy with 2^64bit size and UFS has 1TB file size limit
> (depends on solaris version)

So even on Solaris, "no segments ever" is actually a pretty awful idea.
As it stands, the code would fail on tables > 1TB.

I'm thinking we need to reconsider this patch.  Rather than disabling
segmentation altogether, we should see it as allowing use of segments
larger than 1GB.  I suggest that we ought to just flat rip out the "non
segmenting" code paths in md.c, and instead look into what segment sizes
are appropriate on different platforms.

            regards, tom lane

pgsql-patches by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: [HACKERS] Fix for large file support (nonsegment mode support)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Fix for large file support (nonsegment mode support)