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" <[EMAIL PROTECTED]> To: "Tom Lane" <[EMAIL PROTECTED]> Cc: "Rod Taylor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > Increase signal to noise ratio. http://www.targabot.com >
