From: Thomas Pundt <mlists@rp-online.de>
To: pgsql-sql@postgresql.org
To: mario.splivalo@mobart.hr
Cc: Havasvölgyi Ottó <h.otto@freemail.hu>
Subject: Re: Postgres 7.4.9 slow!
Date: Fri, 21 Oct 2005 14:52:59 +0200
Message-ID: <200510211452.59642.mlists@rp-online.de> (raw)
In-Reply-To: <1129898066.27326.6.camel@ekim>
References: <1129893226.25351.3.camel@ekim>
<006701c5d637$2d7b5550$6400a8c0@OTTO>
<1129898066.27326.6.camel@ekim>
On Friday 21 October 2005 14:34, Mario Splivalo wrote:
| On Fri, 2005-10-21 at 14:01 +0200, Havasvölgyi Ottó wrote:
| > Mike,
| >
| > Please send the EXPLAIN ANALYZE of the two versions of the query.
^^^^^^^^^^^^^^^
| There they are, they are both the same:
|
| join_test=# select version();
| version
| ---------------------------------------------------------------------------
|------------------------------------------- PostgreSQL 7.4.9 on
| i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.2 20050808 (prerelease)
| (Ubuntu 4.0.1-4ubuntu9)
| (1 row)
|
| join_test=# \timing
| Timing is on.
| join_test=# set enable_seqscan to off;
| SET
| Time: 0.715 ms
| join_test=# explain select p.phone, count(*) from phones p left join
| table_data d on p.phone = d.phone group by p.phone having count(*) > 1
| order by count(*) desc;
this is not what Otto requested; please send the output of
EXPLAIN ANALYZE select p.phone, count(*) from phones p left join
table_data d on p.phone = d.phone group by p.phone having count(*) > 1
order by count(*) desc;
for both versions.
Ciao,
Thomas
--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
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: mlists@rp-online.de, mario.splivalo@mobart.hr, h.otto@freemail.hu
Subject: Re: Postgres 7.4.9 slow!
In-Reply-To: <200510211452.59642.mlists@rp-online.de>
* 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