From: Tom Lane <tgl@sss.pgh.pa.us>
To: mario.splivalo@mobart.hr
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres 7.4.9 slow!
Date: Fri, 21 Oct 2005 10:20:07 -0400
Message-ID: <21209.1129904407@sss.pgh.pa.us> (raw)
In-Reply-To: <1129893226.25351.3.camel@ekim>
References: <1129893226.25351.3.camel@ekim>
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.
regards, tom lane
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: tgl@sss.pgh.pa.us, mario.splivalo@mobart.hr
Subject: Re: Postgres 7.4.9 slow!
In-Reply-To: <21209.1129904407@sss.pgh.pa.us>
* 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