Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
От | Rod Taylor |
---|---|
Тема | Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0; |
Дата | |
Msg-id | 081501c0a257$28716b30$2205010a@jester обсуждение исходный текст |
Ответ на | 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0; ("Rod Taylor" <rod.taylor@inquent.com>) |
Список | pgsql-general |
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@selectacast.net> To: "Tom Lane" <tgl@sss.pgh.pa.us> Cc: "Rod Taylor" <rod.taylor@inquent.com>; <pgsql-general@postgresql.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.taylor@inquent.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@selectacast.net > Increase signal to noise ratio. http://www.targabot.com >
В списке pgsql-general по дате отправления: