Re: [PERFORM] Left joining against two empty tables makes a query SLOW

[Gnanavel S]

On 7/28/05, Chris Travers <[EMAIL PROTECTED]> 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.