Postgres Pro
Downloads
Home   >   mailing lists

Re: Different runtime on the same query - Mailing list pgsql-general

From Tom Lane
Subject Re: Different runtime on the same query
Date
Msg-id 5307.1087239519@sss.pgh.pa.us
Whole thread Raw
In response to Different runtime on the same query  (NMB Webmaster <webmaster@nmb.it>)
List pgsql-general
Tree view 
NMB Webmaster <webmaster@nmb.it> writes:
> I have two database quite similar, one has more tables than the other.

Are both of them vacuumed/analyzed recently?  The slow plan seems to be
estimating many more rows out of the e/m join than the other one.

> My Postgres version is 7.2.3. Please help me , it is very important to
> me to tune this query.

I'd recommend an update, myself.  7.2.3 is old...

            regards, tom lane

pgsql-general by date:

Previous
From: Duane Lee - EGOVX
Date:
Subject: Re: Keep history of modifications
Next
From: "Dann Corbit"
Date:
Subject: Re: Opteron scaling with PostgreSQL