From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | subselects doesn't work in v7.0.3 |
Date: | 2001-01-04 10:29:04 |
Message-ID: | 200101041029.f04AT4U77936@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
jose (jose(at)sferacarta(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
subselects doesn't work in v7.0.3
Long Description
Version: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
- I'm trying the following query in a table with 1973093 rows:
EXPLAIN select count(*)
from marche
where ristampa = 'S'
and marca in
(
select marca from marche where ristampa is null and
data_lotto between '1998/07/01' and '1999/01/31'
);
NOTICE: QUERY PLAN:
Aggregate (cost=98854229180.08..98854229180.08 rows=1 width=4)
-> Seq Scan on marche (cost=0.00..98854229130.75 rows=19731 width=4)
SubPlan
-> Materialize (cost=50101.13..50101.13 rows=6577 width=12)
-> Seq Scan on marche (cost=0.00..50101.13 rows=6577 width=12)
EXPLAIN
- but it takes to many time: (after about 16 hours I interrupt the query)
verde:/var/lib/postgreSQL$ time psql interno < ./sql
Cancel request sent
ERROR: Query was cancelled.
ERROR: Query was cancelled.
real 954m44.582s
user 0m0.020s
sys 0m0.000s
- I tried the same query on DBMaker and it takes only about 1 minute.
dmSQL>
USE db #1 disconnected from db:<interno> by user:<sysadm>
real 1m10.070s
user 0m0.020s
sys 0m0.020s
- I tried the same query in a table with few rows and it
seems to work.
Sample Code
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | bart sikkes | 2001-01-04 21:46:01 | postgresql on vax? |
Previous Message | Karel Zak | 2001-01-04 08:08:02 | Re: Output of date_part('quarter', date) |