postgres
postgres copied to clipboard
Transactions always re-query all types leading to huge delay
Hey,
We're noticing big delays on certain transactions, we tracked it down to be the 'fetch types' functionality that queries select b.oid, b.typarray from pg_catalog.pg_type a left join pg_catalog.pg_type b on b.oid = a.typelem where a.typcategory = 'A' group by b.oid, b.typarray order by b.oid.
Each transaction re-fetches the types, disabling that feature however threw errors: PostgresError: malformed array literal: ""
Is there anything we can do against this delay? It delays them by 200ms+ on our side.