On Wed, Aug 27, 2003 at 05:40:05PM -0400, Michael Guerin wrote:
> ex. query: select * from x where id in (select id from y);
> There's an index on each table for id.  SQL Server takes <1s to return, 
> postgresql doesn't return at all, neither does explain analyze.

This particular form of query is a known performance problem for PostgreSQL
7.3 and earlier -- the problem should hopefully be fixed in 7.4 (currently
in beta). Check the archives for more discussion on this topic.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to