Thread

1. Problem with complex query

   Oleg Broytmann <phd@sun.med.ru> — 1999-02-24T13:03:13Z

   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?
   
   Oleg.
   ---- 
       Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
              Programmers don't die, they just GOSUB without RETURN.
   
   
   

2. Re: [HACKERS] Problem with complex query

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-05-09T14:57:16Z

   > 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, Pennsylvania 19026