Skip to content

Removed distinct clause causing performance degradation in Postgres 17

Bartek Wronarequested to merge
bw_postgres17_perf_fix into develop

Removed distinct clause causing Postgres 17 planner to skipping using Index Scan (referencing hive_X_APP__keyauth_k table PK index) and performing Hash join causing significant performance degradation

Merge request reports