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 ;-)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
