slow queries over information schema.tables - Mailing list pgsql-hackers

From Pavel Stehule
Subject slow queries over information schema.tables
Date
Msg-id CAFj8pRBUCX4LZ2rA2BbEkdD6NN59mgx+BLo1gO08Wod4RLtcTg@mail.gmail.com
Whole thread Raw
Responses Re: slow queries over information schema.tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi

one customer reported slow queries over information_schema.tables. There is newer used a index over relname probably due casting to information_schema.sql_identifier.

Slow query

select * from information_schema.tables where table_name = 'pg_class';

Usually, there is hard to fix it on application level due corporate environment.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [Todo item] Add entry creation timestamp column topg_stat_replication
Next
From: Fabien COELHO
Date:
Subject: Re: doc - improve description of default privileges