Hi Tom,
> You didn't say what PG version you are using, but I'd venture to bet
> it is pre-7.4.
Sorry I didn't give the version number, here is the output from select
version():
PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.3
This is the first time that we have compiled the system from source,
previously we used rpm, but it seems very straight forward. I don't know if
there may have been something we did wrong there.
I understand that every DB environment is different, but it sounds like for
the example I gave, you expected that the NOT IN optimization would have
chosen a better plan. As to why it didn't I have no idea at this stage. If
there is anything you want me to do to test it, for example on the
regression test DB, then let me know.
regards
Iain