From: | Reini Urban <rurban(at)x-ray(dot)at> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: How large file is really large - pathconf results |
Date: | 2008-03-18 22:11:46 |
Message-ID: | 47E03E22.5090102@x-ray.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Zdenek Kotala schrieb:
> Regarding to discussion about large segment size of table files a test
> pathconf function (see
> http://www.opengroup.org/onlinepubs/009695399/functions/pathconf.html)
>
> You can see output there:
>
> _PC_FILESIZEBITS - 3rd column
> _PC_LINK_MAX - 4th column
> _PC_NAME_MAX - 5th column
> _PC_PATH_MAX - 6th column
>
>
> Solaris Nevada ZFS 64 -1 255 1024
> UFS 41 32767 255 1024
> FAT 33 1 8 1024
> NFS 41 32767 255 1024
> Solaris 8 UFS 41 32767 255 1024
> NFS 40 32767 255 1024
> Centos4(2.6.11) EXT3 64 32000 255 4096
> XFS 64 2147483647 255 4096
> Mac OSX leopard HFS+ 64 32767 255 1024
cygwin 1.5 on NTFS. But 1.7 will a have much larger _PC_PATH_MAX.
_PC_FILESIZEBITS undefined
_PC_LINK_MAX = 8
_PC_NAME_MAX = 260
_PC_PATH_MAX = 257
So this is really bad.
--
Reini Urban
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-03-18 22:14:32 | Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that |
Previous Message | Simon Riggs | 2008-03-18 22:08:04 | Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one |