Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;

Sorry... Exact same data. Did a pg_dumpall from one to the other
first, then analyzed.
--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.
----- Original Message -----
From: "Joseph Shraibman" <jks(at)selectacast(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com>;
<pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, February 28, 2001 6:12 PM
Subject: Re: [GENERAL] 7.0 vs 7.1 running select count(*) FROM table
WHERE (SELECT count(*) ) > 0;

> 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?
>
> --
> Joseph Shraibman
> jks(at)selectacast(dot)net
> Increase signal to noise ratio. http://www.targabot.com
>