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)
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 |
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 |