From: | Thomas Pundt <mlists(at)rp-online(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, mario(dot)splivalo(at)mobart(dot)hr |
Cc: | Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu> |
Subject: | Re: Postgres 7.4.9 slow! |
Date: | 2005-10-21 12:52:59 |
Message-ID: | 200510211452.59642.mlists@rp-online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----
From | Date | Subject | |
---|---|---|---|
Next Message | Wiebe Cazemier | 2005-10-21 14:13:47 | Delete rule chain stops unexpectedly |
Previous Message | tobbe | 2005-10-21 12:44:52 | Re: Sql - Error : Relation tmp_datos already exists |