<div dir="ltr">Hi,<div><br></div><div>Is there a way to cache these queries or turn them off as pgpool is doing thousands of them a second. I tried setting <span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;font-weight:bold">relcache_expire=60 but it doesn't seem to help.</span><br>
</div><div><br></div><div>example queries: </div><div><br></div><div>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'</div>
<div> 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_'<br></div><div><br></div><div>Thanks<br></div></div>