Re: [PATCHES] Fix for large file support (nonsegment mode support)

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Zeugswetter Andreas OSB SD <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-patches(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] Fix for large file support (nonsegment mode support)
Date: 2008-03-11 16:07:30
Message-ID: 47D6AE42.7000608@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane napsal(a):
> "Zeugswetter Andreas OSB SD" <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at> writes:
>> Exactly, e.g. AIX is one of those. jfs (not the newer jfs2) has an
>> option
>> to enable large files, which is not the default and cannot be changed
>> post crfs.
>> And even if it is enabled, jfs has a 64 Gb filesize limit !
>> Anybody know others that support large but not huge files ?
>
> Yeah, HPUX 10 is similar --- 128GB hard maximum. It does say you
> can convert an existing filesystem to largefile support, but it has
> to be unmounted.
>
> These examples suggest that maybe what we want is not so much a "no
> segments ever" mode as a segment size larger than 1GB.

Patch allows to use bigger than 2/4GB segment files and it is possible
changed it in source file. But how it was mentioned in this thread maybe
somethink like this "CREATE TABLESPACE name LOCATION '/my/location'
SEGMENTS 10GB" should good solution. If segments is not mentioned then
default value is used.

Zdenek

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-11 16:11:13 Re: Autovacuum vs statement_timeout
Previous Message Bruce Momjian 2008-03-11 15:53:21 Re: Patch for monitoring.sgml

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-03-11 16:20:57 Re: [PATCHES] Fix for large file support (nonsegment mode support)
Previous Message Cliff Nieuwenhuis 2008-03-11 15:10:15 encoding problems