Re: Odd new symptom - database locking up on a query

"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> could you restate whether an index built with the order b,a would be a good
> candidate for use in a query using a where clause of b = x AND a IN (long
> list) please?

Such an index would only be matched to the b = x clause.

If you can think of a way to improve that without materially increasing
the search time in indxpath.c, I'm all ears...

            regards, tom lane