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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: Doug Fields <dfields-pg-general(at)pexicom(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Odd new symptom - database locking up on a query
Date: 2002-07-09 03:45:36
Message-ID: 791.1026186336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-07-09 04:07:59 Re: Speeding up subselect ?
Previous Message Ricardo Junior 2002-07-09 03:41:03 Re: PostgreSQL doesn't use indexes even is enable_seqscan