Skip site navigation (1) Skip section navigation (2)

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

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
Subject: Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
Date: 2001-02-28 23:12:38
Message-ID: 3A9D85E6.7B591B54@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Jean-Christophe BoggioDate: 2001-02-28 23:32:19
Subject: Performance tuning
Previous:From: John MaddenDate: 2001-02-28 23:10:19
Subject: how to vacuum from cron?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group