Tom Lane wrote:
> "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com> writes:
> > Query on 7.0 on Ultra II took over 5 hours. Query on 7.1 on x86 took
> > under 10 seconds. Same data.
> Good ... I guess, because I'm not sure why the difference. We haven't
> done very much in the optimizer since 7.0. What are the full
> declarations of these tables and their indexes?
> regards, tom lane
Sometimes your production and development machines have different data
so behave differently. With postgres this is more of a problem than in
general because of the planner.
RT: have you tried the same query with the same data on your development
machine with 7.0?
Increase signal to noise ratio. http://www.targabot.com
In response to
pgsql-general by date
|Next:||From: Jean-Christophe Boggio||Date: 2001-02-28 23:32:19|
|Subject: Performance tuning|
|Previous:||From: John Madden||Date: 2001-02-28 23:10:19|
|Subject: how to vacuum from cron?|