>>>>> "VK" == Vivek Khera <khera at kcilink.com> writes: VK> see if that speeds it up, since PG will then be able to use the VK> index. It sounds like the users5 index is unused, since the query is VK> not against a fixed string but on a function. make that "users4 index is unused".