On 7/28/05, Chris Travers <chris(at)travelamericas(dot)com> wrote:
>
> 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 ....;
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.