Skip site navigation (1) Skip section navigation (2)

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

From: Gnanavel S <s(dot)gnanavel(at)gmail(dot)com>
To: Chris Travers <chris(at)travelamericas(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Left joining against two empty tables makes a query SLOW
Date: 2005-07-29 04:05:40
Message-ID: eec3b03c050728210512f3fed5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

Responses

pgsql-performance by date

Next:From: Luke LonerganDate: 2005-07-29 04:07:12
Subject: Re: [PATCHES] COPY FROM performance improvements
Previous:From: Luke LonerganDate: 2005-07-29 04:03:20
Subject: Re: [PATCHES] COPY FROM performance improvements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group