adding column with pgadmin gui takes > 800 secs.

Поиск
Список
Период
Сортировка
От wouter.aukema@gmail.com
Тема adding column with pgadmin gui takes > 800 secs.
Дата
Msg-id 1166439407.717834.158010@n67g2000cwd.googlegroups.com
обсуждение исходный текст
Список pgadmin-support
I'm having an interesting issue, not sure if it's the server or pgadmin
client:

When trying to add a column (with pgadmin gui) to an already existing
table, a query as shown below is executed on the server:
SELECT    format_type(t.oid,NULL) AS typname,CASE WHEN typelem > 0 THEN typelem ELSE t.oid END as
elemoid,typlen,typtype,t.oid,nspname,      (    SELECT    COUNT(1)    FROM     pg_type t2    WHERE     t2.typname =
t.typname)      > 1 AS isdup         FROM pg_type t         JOIN pg_namespace nsp ON typnamespace=nsp.oid        WHERE
(NOT(typname = 'unknown' AND nspname = 'pg_catalog'))
 
AND typisdefined AND typtype IN ('b', 'c', 'd')AND typname NOT IN
(SELECT relname FROM pg_class WHERE relnamespace = typnamespace AND
relkind != 'c')        ORDER BY CASE WHEN typtype='d' THEN 0 ELSE 1 END,
(t.typelem>0)::bool, 1

This takes over 800 secs to complete.
Is this normal, against a database with 385 schemas?



(I am posting to this group for the first time, please be kind ;-)



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

Предыдущее
От: Laurent ROCHE
Дата:
Сообщение: Re : No text for error messages only numbers
Следующее
От: "Roderick A. Anderson"
Дата:
Сообщение: [Q] (S)RPM for 1.6.1