Postgres Pro
Downloads
Home   >   mailing lists

Re: Incredibly slow queries oninformation_schema.constraint_column_usage? - Mailing list pgsql-general

From Alexey Bashtanov
Subject Re: Incredibly slow queries oninformation_schema.constraint_column_usage?
Date
Msg-id ed17ca14-9087-e80d-9b3a-23d7234391c1@imap.cc
Whole thread Raw
In response to Incredibly slow queries oninformation_schema.constraint_column_usage?  (Viktor Fougstedt <viktor@chalmers.se>)
List pgsql-general
Tree view
Hello Viktor,

There was a known slowness issue in this view.
It was fixed in PG 10: https://www.postgresql.org/message-id/flat/2d533e5b-687a-09fa-a772-dac9e6cf9dd4@imap.cc#2d533e5b-687a-09fa-a772-dac9e6cf9dd4@imap.cc
You can try to use a solution from there to create a faster view that returns the same data as information_schema.constraint_column_usage.
I wouldn't be surprised if it was safe to replace information_schema.constraint_column_usage itself, but I cannot guarantee it.

Best,
  Alex

pgsql-general by date:

Previous
From: Olleg Samoylov
Date:
Subject: PostgreSQL 10.3 and Ubuntu
Next
From: Gunnar Halvorsen
Date:
Subject: JDBC4 and setting statement_timeout: responds "is not yet implemented"