I need to query two huge tables (more than milion records). Besides other conditions, there is also a not equal (
where condition on a columns pair of
varchar type. It has to exclude one in a million.
Values in the column are unique, same in both tables, so I have to exclude from joining rows from two tables which have identical values in that particular column.
Is a standard b-tree type index suitable, or would some other index type be more suitable for a not equal (
pg-strom extension? Could
pg-strom (utilizing GPU) enhance speed of a not equal comparison in the