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

From: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
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 19:57:15
Message-ID: 4AABFD1B.1050005@mark.mielke.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 09/12/2009 03:48 PM, Stephen Frost wrote:
> This would allow for 220M+ databases. I'm not sure how bad it'd be to
> introduce another field to pg_database which provides the directory (as
> it'd now be distinct from the oid..) or if that might require alot of
> changes. Not sure how easy it'd be to implement something to address
> this problem while we continue to tie the directory name to the oid.
>

Other than bragging rights - what part of this would be a GOOD thing? :-)

My God - I thought 32k databases in the same directory was insane.
220M+???????

Hehehe...

If you can patch PostgreSQL to support such extremes without hurting my
performance - I'll shut up and leave you be. :-)

Cheers,
mark

--
Mark Mielke<mark(at)mielke(dot)cc>

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2009-09-12 20:02:11 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Previous Message Mark Mielke 2009-09-12 19:52:32 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:02:11 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Previous Message Mark Mielke 2009-09-12 19:52:32 Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.