From: Gnanavel S <s.gnanavel@gmail.com>
To: Chris Travers <chris@travelamericas.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Left joining against two empty tables makes a query SLOW
Date: Fri, 29 Jul 2005 09:35:40 +0530
Message-ID: <eec3b03c050728210512f3fed5@mail.gmail.com> (raw)
In-Reply-To: <42E90E19.3030702@travelamericas.com>
References: <42E86A03.1070803@travelamericas.com>
<eec3b03c050728025527b91961@mail.gmail.com>
<42E90E19.3030702@travelamericas.com>
On 7/28/05, Chris Travers <chris@travelamericas.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.
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: s.gnanavel@gmail.com, chris@travelamericas.com
Subject: Re: Left joining against two empty tables makes a query SLOW
In-Reply-To: <eec3b03c050728210512f3fed5@mail.gmail.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