From: Havasvölgyi Ottó <h.otto@freemail.hu>
To: pgsql-sql@postgresql.org
Subject: Re: Postgres 7.4.9 slow!
Date: Fri, 21 Oct 2005 14:01:32 +0200
Message-ID: <006701c5d637$2d7b5550$6400a8c0@OTTO> (raw)
References: <1129893226.25351.3.camel@ekim>
Mike,
Please send the EXPLAIN ANALYZE of the two versions of the query.
Best Regards,
Otto
----- Original Message -----
From: "Mario Splivalo" <mario.splivalo@mobart.hr>
To: <pgsql-sql@postgresql.org>
Sent: Friday, October 21, 2005 1:13 PM
Subject: [SQL] Postgres 7.4.9 slow!
> Hello! I'm not sure if this belongs to this mailing list, if not, please
> tell me to redirect to where it belongs.
>
> 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, with SET ENABLE_SEQSCAN TO OFF, and I get 9-11
> seconds for that query. Query plan shows that postgres is using both
> indexes on both tables (one index is set on primary key, naturaly, and
> other is manualy set on foreign key in 'child' table). That is
> acceptable.
>
> 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.
>
> Has anyone noticed extreeme slowdown of postgres 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."
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
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: h.otto@freemail.hu
Subject: Re: Postgres 7.4.9 slow!
In-Reply-To: <006701c5d637$2d7b5550$6400a8c0@OTTO>
* 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