/claim #823

Description

Optimizes omni_schema.dependency view for performance (~7.5x improvement).

Changes

• omni_schema.dependency:
  • Fixed cartesian product bug in operator namespace joins (O(N*M) -> O(N)).
  • Pushed deptype != 'i' filter into UNION ALL branches to reduce intermediate set size.
  • Selected only necessary columns (refclassid, refobjid, refobjsubid) instead of full pg_depend composite.
• Tests:
  • Added regression test for operator with cross-schema types.
• Version:
  • Bumped omni_schema to 0.3.1.

Benchmarks