Re: BUG #4690: an select query is not using the index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: vikas <vikas(dot)dubey(at)newgen(dot)co(dot)in>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4690: an select query is not using the index
Date: 2009-03-04 16:49:17
Message-ID: 3212.1236185357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> vikas wrote:
>> PostgreSQL version: PostgreSQL 7.3

> Time to upgrade.

Indeed. 7.4 was the first release that had even an inkling of how to
optimize IN (sub-SELECT) clauses.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Oscar Bejarano 2009-03-04 19:05:45 BUG #4693: When I use the order by it gets me an error, but if i use it without order by it's a correct query.
Previous Message Peter Much 2009-03-04 16:28:41 BUG #4692: VACUUM: write to WAL gets very slow and seems redundant