Re: How many tables is too many tables?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How many tables is too many tables?
Дата
Msg-id 1832.1127186483@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How many tables is too many tables?  ("cydatamatt@gmail.com" <cydatamatt@gmail.com>)
Список pgsql-performance
"cydatamatt@gmail.com" <cydatamatt@gmail.com> writes:
> We currently have around 400,000 tables
> and I would estimate that the vast majority of these tables are
> relatively small (less than 200 rows).

Stop right there, and go redesign your schema.  This is unbelievably
wrong :-(

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index Selection: ORDER BY vs. PRIMARY KEY
Следующее
От: John A Meinel
Дата:
Сообщение: Re: How many tables is too many tables?