Horton

Re: [HACKERS] Bug on complex join

Hannu Krosing <hannu@trust.ee>

View thread
From: Hannu Krosing <hannu@trust.ee>
To: phd2@earthling.net
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 1999-03-09T12:56:30Z
Lists: pgsql-hackers 
Oleg Broytmann wrote:
> 
> Hello!
> 
>    Another symptom. The query
> 
> SELECT cn.date_i, cn.pos_id
>    FROM central cn
>       WHERE cn.date_i >= current_date - '300 days'::timespan
> 
> returns 3156 rows. But this:
> 
> SELECT cn.date_i, p.subsec_id, cn.pos_id, p.pos_id
>    FROM central cn, shops sh, districts d, positions p
>       WHERE cn.date_i >= current_date - '300 days'::timespan

this should return
   3156 * count(shops) * count(districts) * count(positions)

which is probably too much for the backend ;(

-----------------------
Hannu