Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-899

PostgresConnection.initTypeRegistry() takes ~24 mins

    XMLWordPrintable

    Details

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                gunnar.morling Gunnar Morling
                Reporter:
                dajerome David Jerome
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: