Re: Number of tables

Fabio La Farcioli wrote:
> Hi to all,
>
> i am developing a web app for thousands users (1.000/2.000).
>
> Each user have a 2 table of work...I finally have 2.000 (users) x 2
> tables = 4.000 tables!

As a someone with a ~50K-table database, I can tell you it's definitely
possible to survive with such a layout :-)

However, expect very slow (hours) pg_dump, \dt and everything else that
requires reading schema information for the whole db.


Mike