Details
-
Bug
-
Resolution: Done
-
Major
-
0.8.2.Final
-
None
Description
For our database, PostgresConnection.initTypeRegistry() takes ~24 mins.
Here are the counts for the queries used in the method :
SELECT count(*) FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) WHERE n.nspname != 'pg_toast' and t.typcategory='A'; count ------- 78,672 (1 row)
SELECT count(*) FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) WHERE n.nspname != 'pg_toast' and t.typcategory<>'A'; count ------- 81,287 (1 row)
Our pg_catalog.pg_type table contains 199,280 rows.
Our pg_catalog.pg_namespace table contains 1,541 rows.
