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

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> I believe the filesystem limit the OP is hitting is on the number of
> *subdirectories* per directory, not on the number of plain files.

Right, I'm not entirely sure how we got onto the question of number of
tables.

> So the question I would ask goes more like "do you really need 32K
> databases in one installation?  Have you considered using schemas
> instead?"  Databases are, by design, pretty heavyweight objects.

I agree, but at the same time, we might: a) update our documentation to
indicate it depends on the filesystem, and b) consider how we might
work around this limit (and if we feel the effort to be worth it).
Thanks,
    Stephen