Re: How large file is really large - pathconf results

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

In response to

Responses

Browse pgsql-hackers by date

  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