Gnanavel S wrote:

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 ....;

Secondly, the project table has *never* had anything in it. So where are these numbers coming from?

Best Wishes,
Chris Travers
Metatron Technology Consulting

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to