Large number of rows in pg_type and slow gui (pgadmin) refresh

Поиск
Список
Период
Сортировка
От Robert Klaus
Тема Large number of rows in pg_type and slow gui (pgadmin) refresh
Дата
Msg-id 00ba01cde927$72044050$560cc0f0$@com
обсуждение исходный текст
Список pgsql-novice

We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod) AS typname FROM pg_type".

 

My manager says this is only a small number compared to what is expected by next summer.

 

When I run this select statement on the database server it returns in under 1 second but it takes a minute to open some tabs using pgAmin III (1.16.1).

 

Is there a workaround for this - most of the rows returned are from one schema.  If we could elimiate it from the listed schemas it would help.  Is this possible in pgAdmin III?

 

Our database server is at 8.4

 

Robert

 

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

Предыдущее
От: Mick
Дата:
Сообщение: Need help cleaning up PostgreSQL installs on Ubuntu 12.10
Следующее
От: jody
Дата:
Сообщение: db dump from php