Re: Poor performance with row wise comparisons

From: Greg Sabino Mullane Sent: Friday, February 7, 2025 9:43 AM To: Jon Emord Cc: pgsql-performance@lists.postgresql.org Subject: Re: Poor performance with row wise comparisons You don't often get email from htamf...@gmail.com. Learn why this is important<https://aka.ms/LearnAbou

Poor performance with row wise comparisons

Hi everyone I wrote a query to iterate over two different columns. These columns have a composite unique index on them, and I’m only retrieving those columns. I found that there was a very large difference in performance when using row wise comparison versus a column comparison. The column comp