Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, fulan Peng <fulanpeng(at)gmail(dot)com>
Subject: Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Date: 2009-09-12 20:02:11
Message-ID: 11995.1252785731@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Mark Mielke (mark(at)mark(dot)mielke(dot)cc) wrote:
>> No matter what scheme PostgreSQL uses for storing the data, there can be
>> underlying file system limitations.

> This is true, but there's a reason we only create 1GB files too. I
> wouldn't be against a scheme such as described to minimize the impact to
> PG of these limitations.

There are plenty of filesystems available that do not have this silly
limitation, so I don't see a reason for us to work around it. If the
OP is on a platform that only offers UFS and ZFS, and he doesn't like
either of those, maybe he should find another platform.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2009-09-12 20:15:09 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Previous Message Mark Mielke 2009-09-12 19:57:15 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-09-12 20:15:09 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Previous Message Mark Mielke 2009-09-12 19:57:15 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.