Re: 15,000 tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 15,000 tables
Дата
Msg-id 11360.1133453022@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 15,000 tables  (Michael Riess <mlriess@gmx.de>)
Ответы Re: 15,000 tables
Re: 15,000 tables
Re: 15,000 tables
Список pgsql-performance
Michael Riess <mlriess@gmx.de> writes:
> (We NEED that many tables, please don't recommend to reduce them)

No, you don't.  Add an additional key column to fold together different
tables of the same structure.  This will be much more efficient than
managing that key at the filesystem level, which is what you're
effectively doing now.

(If you really have 15000 distinct rowtypes, I'd like to know what
your database design is...)

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: slow insert into very large table
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: 15,000 tables