Is a two column primary key the most performant way to go if (a,b) should be unique but I will only be querying against a?
If you define the primary key as (a,b), then the index will be used when handling queries using a OR a AND b, but not b alone.

If you define the primary key as (b,a), then the index would be used when handling b, b AND a, but not a alone.