PostgreSQL LIKE Performance: CAST, Concat, and OR Comparison
Comparing 6 different LIKE approaches in a migration from bigint LongColumn to text TextColumn with a 2 million row benchmark: CAST+concat, CAST single, text concat, text single, text OR, and CAST OR.
backend
performance
dotnet