Re: selecting data from information_schema.columns performance.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: selecting data from information_schema.columns performance.
Дата
Msg-id 26736.1159758079@sss.pgh.pa.us
обсуждение исходный текст
Ответ на selecting data from information_schema.columns performance.  (Steve Martin <smartin@nec.co.nz>)
Ответы Re: selecting data from information_schema.columns performance.  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
Дерево обсуждения 
Steve Martin <smartin@nec.co.nz> writes:
> I am trying to determine if there is a way to improve the performance
> when selecting data from the information_schema.columns view.

In my experience, there isn't any single one of the information_schema
views whose performance doesn't suck :-(.  Somebody should work on that
sometime.  I haven't looked closely enough to determine where the
bottlenecks are.

            regards, tom lane

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

Предыдущее
От: Steve Martin
Дата:
Сообщение: selecting data from information_schema.columns performance.
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: PostgreSQL runs a query much slower than BDE and