Subject: Re: Postgres 7.4.9 slow!
From: Mario Splivalo <mario.splivalo@mobart.hr>
Reply-To: mario.splivalo@mobart.hr
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <21209.1129904407@sss.pgh.pa.us>
References: <1129893226.25351.3.camel@ekim> <21209.1129904407@sss.pgh.pa.us>
Content-Type: text/plain
Organization: Mob-Art
Date: Fri, 21 Oct 2005 16:32:30 +0200
Message-Id: <1129905150.7740.5.camel@ekim>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Fri, 2005-10-21 at 10:20 -0400, Tom Lane wrote:
> Mario Splivalo <mario.splivalo@mobart.hr> writes:
> > I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> > One has 85000 records, and other has 1000000 records. I've been running
> > the tests on 7.4.3,
> 
> Your later message shows 7.4.8.  Which is it?
> 
> > But, now I downloaded postgres 7.4.9, and i'm running the very same
> > query on the very same database with all the indices and constraints
> > beeing the same (also SET ENABLE_SEQSCAN TO OFF), and I get around
> > 90-110 seconds.
> 
> You sure it's the very same?  The version outputs suggest that these
> might be two different machines; certainly two very different compilers
> were used.  One thing I'd wonder about is whether both databases were
> initialized in the same locale.

Yes, I realized that the new Ubuntu distribution hac gcc4 by default.
I'll compile again both 7.4.8 and 7.4.9 and my home PC, and see what
happens then.

My mention of 7.4.3 is a typo. It's 7.4.8 and 7.4.9.

	Mike
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."