postgres icon indicating copy to clipboard operation
postgres copied to clipboard

Transactions always re-query all types leading to huge delay

Open phosmium opened this issue 1 year ago • 3 comments

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.

phosmium avatar Jun 24 '24 19:06 phosmium