babelfish-for-postgresql / babelfish_extensions / 27833497074

78%

Build Type

push

github

Committed by web-flow

Commit Message

Rewriting Objectpropertyex function in C (#4691)

The PL/pgSQL implementation of OBJECTPROPERTYEX relies on sys.all_objects, an expensive view that joins across multiple catalogs with multiple UNION branches, causing significant overhead which gets carried forward to any function using OBJECTPROPERTYEX.

Hence we are replacing OBJECTPROPERTYEX with a C implementation that uses direct syscache lookups via shared catalog helpers, avoiding view materialization entirely. For non-BaseType properties, it delegates to the existing objectproperty_internal.

Signed-off-by: Rucha Kulkarni <ruchask@amazon.com>

Coverage Stats

331 of 357 new or added lines in 2 files covered. (92.72%)

268 existing lines in 1 file now uncovered.

54701 of 71004 relevant lines covered (77.04%)

588799.2 hits per line