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

2009-03-04 Thread Tom Lane
Peter Eisentraut 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@po

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

2009-03-04 Thread Peter Eisentraut
vikas wrote: The following bug has been logged online: Bug reference: 4690 Logged by: vikas Email address: vikas.du...@newgen.co.in PostgreSQL version: PostgreSQL 7.3 Time to upgrade. Operating system: i686-pc-linux-gnu Description:an select query is not using th

[BUGS] BUG #4690: an select query is not using the index

2009-03-04 Thread vikas
The following bug has been logged online: Bug reference: 4690 Logged by: vikas Email address: vikas.du...@newgen.co.in PostgreSQL version: PostgreSQL 7.3 Operating system: i686-pc-linux-gnu Description:an select query is not using the index Details: hi there is a t