David Gagnon <dgagnon(at)siunik(dot)com> 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