Re: [HACKERS] Not enough memory for complex join

Oleg Broytmann wrote:
> 
>    I played with the query, and found I can remove (AND d.city_id = 2). The
> query executes pretty fast (my database is small). I tried to get
> d.city_id:
> 
> SELECT p.subsec_id, d.city_id
>    FROM  positions p, central cn, shops sh, districts d
>       WHERE cn.pos_id = p.pos_id
>       AND   cn.shop_id = sh.shop_id AND sh.distr_id = d.distr_id
>       AND   cn.date_i >= current_date - '7 days'::timespan
> 
> but postgres eats all memory and dies :(((

What does EXPLAIN say ?

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