From: Mario Splivalo <mario.splivalo@mobart.hr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres 7.4.9 slow!
Date: Fri, 21 Oct 2005 16:32:30 +0200
Message-ID: <1129905150.7740.5.camel@ekim> (raw)
In-Reply-To: <21209.1129904407@sss.pgh.pa.us>
References: <1129893226.25351.3.camel@ekim>
<21209.1129904407@sss.pgh.pa.us>
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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr, tgl@sss.pgh.pa.us
Subject: Re: Postgres 7.4.9 slow!
In-Reply-To: <1129905150.7740.5.camel@ekim>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox