Re: Large # of Tables, Getting ready for the enterprise

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large # of Tables, Getting ready for the enterprise
Дата
Msg-id 22053.966661381@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Large # of Tables, Getting ready for the enterprise  ("carl garland" <carlhgarland@hotmail.com>)
Список pgsql-hackers
"carl garland" <carlhgarland@hotmail.com> writes:
> Currently postgres will support an incredible amount of tables whereas
> Interbase only supports 64K, but the efficiency and performance of the
> pg backend quickly degenerates after 1000 tables.

Current sources fix some problems with large numbers of indexes
(pg_index was being sequentially scanned in several places).  Offhand
I'm not aware of any other significant real-world performance problems
in this area; can you be more specific about what's bothering you?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Functions and Null Values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_attribute growing and growing and growing