Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0; - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
Date
Msg-id 18517.983378938@sss.pgh.pa.us
Whole thread Raw
In response to 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;  ("Rod Taylor" <rod.taylor@inquent.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: trouble configuring Postgres with Identd authentication
Next
From: Bruce Momjian
Date:
Subject: Re: [ANNOUNCE] Addison-Wesley looking for authors