Re: Odd new symptom - database locking up on a query - Mailing list pgsql-general

From Tom Lane
Subject Re: Odd new symptom - database locking up on a query
Date
Msg-id 791.1026186336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd new symptom - database locking up on a query  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
"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



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [INTERFACES] pgaccess problems
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Bug in 7.2.1? -- ERROR: Adding columns with defaults is not implemented.