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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
Date: 2001-02-28 16:48:58
Message-ID: 18517.983378938@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-02-28 17:05:02 Re: Debug messages in beta5
Previous Message Tom Lane 2001-02-28 16:36:24 Re: trouble configuring Postgres with Identd authentication