From: Thomas Pundt <mlists@rp-online.de>
Reply-To: Thomas Pundt <thomas.pundt@rp-online.de>
Organization: RP Online Verlagsgesellschaft mbH
To: pgsql-sql@postgresql.org, mario.splivalo@mobart.hr
Subject: Re: Postgres 7.4.9 slow!
Date: Fri, 21 Oct 2005 14:52:59 +0200
User-Agent: KMail/1.8.3
Cc: =?utf-8?q?Havasv=C3=B6lgyi_Ott=C3=B3?= <h.otto@freemail.hu>
References: <1129893226.25351.3.camel@ekim>
	<006701c5d637$2d7b5550$6400a8c0@OTTO>
	<1129898066.27326.6.camel@ekim>
In-Reply-To: <1129898066.27326.6.camel@ekim>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200510211452.59642.mlists@rp-online.de>

On Friday 21 October 2005 14:34, Mario Splivalo wrote:
| On Fri, 2005-10-21 at 14:01 +0200, Havasv=C3=B6lgyi Ott=C3=B3 wrote:
| > Mike,
| >
| > Please send the EXPLAIN ANALYZE of the two versions of the query.
                    ^^^^^^^^^^^^^^^

| There they are, they are both the same:
|
| join_test=3D# select version();
| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0version
| -------------------------------------------------------------------------=
=2D-
|------------------------------------------- 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=3D# \timing
| Timing is on.
| join_test=3D# set enable_seqscan to off;
| SET
| Time: 0.715 ms
| join_test=3D# explain select p.phone, count(*) from phones p left join
| table_data d on p.phone =3D d.phone group by p.phone having count(*) > 1
| order by count(*) desc;

this is not what Otto requested; please send the output of=20

  EXPLAIN ANALYZE select p.phone, count(*) from phones p left join
  table_data d on p.phone =3D d.phone group by p.phone having count(*) > 1
  order by count(*) desc;

for both versions.

Ciao,
Thomas

=2D-=20
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----