Re: [HACKERS] Problem with complex query - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Problem with complex query
Date
Msg-id 199905091457.KAA22239@candle.pha.pa.us
Whole thread Raw
In response to Problem with complex query  (Oleg Broytmann <phd@sun.med.ru>)
Responses Re: [HACKERS] Problem with complex query
List pgsql-hackers
> Hello!
> 
> Query:
> 
> SELECT DISTINCT p.subsec_id
>    FROM central cn, shops sh, districts d, positions p
>       WHERE cn.shop_id = sh.shop_id AND sh.distr_id = d.distr_id
>       AND   d.city_id = %d AND cn.pos_id = p.pos_id
>       AND   cn.date_i >= current_date - '7 days'::timespan
> 
> While running postgres slowly eats all swap space (30 Meg) and aborts:
> 
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or
> while processing the request.
> 
>    Is it I just have not enough memory or bug?

Not sure how to comment on this.  Is 6.5beta any better?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] inet data type regression test fails
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Oops, I seem to have changed UNION's behavior