Re: limits?

On Jun 23, 2008, at 10:56 AM, Kynn Jones wrote:

>
>
>
>
> How can I find the limits (if any) on things such as the maximum
> number of tables, views, indices, columns-per-table, size of
> database, etc.?
>
> (At the moment I'm particularly interested any limits that my exist
> on the numbers of tables and views that may exist in any one
> database.)

http://www.postgresql.org/about/ has some of the theoretical limits.

In real use you're unlikely to hit any limits, theoretical or
practical, but if you start to use a silly number of tables and so on
you're likely to hit performance issues eventually. I'm not sure where
that threshold would be, but it's higher than "thousands".

Cheers,
   Steve