Re: Number of tables

From: Mike Ivanov <mikei(at)activestate(dot)com>
To: fabio(dot)lafarcioli(at)molinoalimonti(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Number of tables
Date: 2009-09-01 00:19:01
Message-ID: 4A9C6875.6010607@activestate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2009-09-01 01:01:26 Re: Number of tables
Previous Message Scott Marlowe 2009-08-31 19:15:56 Re: What exactly is postgres doing during INSERT/UPDATE ?