Kristjan Mustkivi <sonicmonkey@xxxxxxxxx> writes: >>> Filter: (((product_code)::text = ($1)::text) AND >>> ((balance_type)::text = ($4)::text)) > But the Primary Key is defined as btree (cage_code, cage_player_id, > product_code, balance_type, version) so this should be exactly that > (apart from the extra "version" column). Oh, interesting. So this is really a datatype mismatch problem. I'd wondered idly why you were getting the explicit casts to text in these conditions, but now it seems that that's key to the problem: the casts prevent these clauses from being matched to the index. What are the declared data types of product_code and balance_type? And of the parameters they're compared to? regards, tom lane
