Re: Different runtime on the same query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: NMB Webmaster <webmaster(at)nmb(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Different runtime on the same query
Date: 2004-06-14 18:58:39
Message-ID: 5307.1087239519@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

NMB Webmaster <webmaster(at)nmb(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2004-06-14 19:51:00 Re: Opteron scaling with PostgreSQL
Previous Message Bruno Wolff III 2004-06-14 17:54:53 Re: doubt