On Fri, 2003-09-12 at 11:05, M. Bastin wrote:
> Hi,
>
> I'd like to know 2 things that should be added to the FAQ:
>
> How many tables can you create in a database?
>
> How many databases can you create on a single PostgreSQL server?
I think that to both questions the answer is that there is no practical
limit within the database. A table takes up some rows in system tables,
and it creates files on disk for its data and its indexes. A database
creates a sub-directory containing its tables. Since tables are able to
hold many millions of rows, I cannot imagine there could be any
practical limit there.
You will run out of inodes or disk space long before you run out of
database resources.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Let the wicked forsake his way, and the unrighteous
man his thoughts; and let him return unto the LORD,
and He will have mercy upon him; and to our God, for
he will abundantly pardon." Isaiah 55:7