> > > vacuum & reindex the department and project table as the planner > expects there are 1060 rows but actually returning nothing.
I guess I should have mentioned that I have been vacuuming and reindexing at least once a week, and I did so just before running this test. Normally I do: vacuum analyze; reindex database ....;
reindex the tables separately.
Secondly, the project table has *never* had anything in it. So where are these numbers coming from?
pg_statistics
Best Wishes, Chris Travers Metatron Technology Consulting
-- with regards, S.Gnanavel Satyam Computer Services Ltd.