Re: Number of tables - Mailing list pgsql-performance

From Mike Ivanov
Subject Re: Number of tables
Date
Msg-id 4A9C6875.6010607@activestate.com
Whole thread Raw
In response to Number of tables  (Fabio La Farcioli <fabio.lafarcioli@molinoalimonti.com>)
Responses Re: Number of tables  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Next
From: Greg Stark
Date:
Subject: Re: Number of tables