From: Chris Travers <chris@travelamericas.com>
To: Gnanavel S <s.gnanavel@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Left joining against two empty tables makes a query
Date: Thu, 28 Jul 2005 09:55:53 -0700
Message-ID: <42E90E19.3030702@travelamericas.com> (raw)
In-Reply-To: <eec3b03c050728025527b91961@mail.gmail.com>
References: <42E86A03.1070803@travelamericas.com>
<eec3b03c050728025527b91961@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: chris@travelamericas.com, s.gnanavel@gmail.com
Subject: Re: Left joining against two empty tables makes a query
In-Reply-To: <42E90E19.3030702@travelamericas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox