Re: Number of tables

Поиск
Список
Период
Сортировка
От Mike Ivanov
Тема Re: Number of tables
Дата
Msg-id 4A9C6875.6010607@activestate.com
обсуждение исходный текст
Ответ на Number of tables  (Fabio La Farcioli <fabio.lafarcioli@molinoalimonti.com>)
Ответы Re: Number of tables  (Greg Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Number of tables