Postgres Professional
en

Re: Number of tables

От: Jochen Erwied
Тема: Re: Number of tables
Дата: ,
Msg-id: 1286032546.20090820094912@erwied.eu
(см: обсуждение, исходный текст)
Ответ на: Number of tables  (Fabio La Farcioli)
Список: pgsql-performance

Скрыть дерево обсуждения

Getting time of a postgresql-request  ("Kai Behncke", )
 Re: Getting time of a postgresql-request  (Russell Smith, )
  Re: Getting time of a postgresql-request  (Pierre Frédéric Caillaud<>, )
 Number of tables  (Fabio La Farcioli, )
  Re: Number of tables  (Jochen Erwied, )
  Re: Number of tables  (Craig Ringer, )
   Re: Number of tables  (Fabio La Farcioli, )
  Re: Number of tables  (Craig James, )
   Re: Number of tables  (Greg Stark, )
    Re: Number of tables  (Craig James, )
     Re: Number of tables  (Greg Stark, )
      Re: Number of tables  (Alvaro Herrera, )
       Re: Number of tables  (Greg Stark, )
        Re: Number of tables  ("Kevin Grittner", )
       Re: Number of tables  (Robert Haas, )
      Re: Number of tables  (Jerry Champlin, )
  Re: Number of tables  (Mike Ivanov, )
   Re: Number of tables  (Greg Stark, )
    Re: Number of tables  (Mike Ivanov, ) 
Thursday, August 20, 2009, 9:01:30 AM you wrote:

> 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!

If all tables are created equal, I would rethink the design. Instead of
using 2 tables per user I'd use 2 tables with one column specifying the
user(-id).

Especially changes in table layout would require you to change up to 2000
tables, which is prone to errors...

--
Jochen Erwied     |   home:      +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work:   +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile:        +49-173-5404164

В списке pgsql-performance по дате сообщения:

Предыдущее:
От: Ivan Voras
Дата:
Сообщение: Re: PG 8.3 and server load
Следующее:
От: Robert Haas
Дата:
Сообщение: Re: number of rows estimation for bit-AND operation