[pgpool-general: 2323] thousands of queries to pg_class / second

[Nathan Brennan]

Hi,

Is there a way to cache these queries or turn them off as pgpool is doing
thousands of them a second. I tried setting relcache_expire=60 but it
doesn't seem to help.

example queries:

SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname =
'table' AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
 SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname =
'table' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131204/aaf0d2c7/attachment.html>