Re: Poor performance with row wise comparisons

Jon Emord writes: >-> Index Only Scan using entity_data_model_id_primary_key_uniq on entity > (cost=0.70..873753.60 rows=15581254 width=31) (actual time=0.093..2712.836 > rows=100 loops=1) > Index Cond: ((ROW(data_model_id, primary_key) >= ROW(123, > 'ABC'::text)) AND (ROW(data_m

Re: Poor performance with row wise comparisons

With limit 101, the plan is ~equivalent to the no limit case explain (analyze, buffers) select data_model_id, primary_key from entity WHERE (data_model_id, primary_key) BETWEEN (123, ‘ABC’) AND (123, ‘DEF’) limit 101;