David Gagnon <dgagnon@xxxxxxxxxx> writes: > Hi all, > > I stop the following statement after 3 minutes.... > > explain analyse select * > From IC > where IC.ICNUM NOT IN (select IRICNUM from IR WHERE IRSTATUT > in (1, 2)) > > > I'm using 8.0.3 on windows. > > Is that a know bug ? Post your schema, and the sizes of the tables in question. Also, a regular EXPLAIN (without ANALYZE) should print the query plan that PG has chosen--post that too. -Doug ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
