Skip site navigation (1) Skip section navigation (2)

Problem with complex query

From: Oleg Broytmann <phd(at)sun(dot)med(dot)ru>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Problem with complex query
Date: 1999-02-24 13:03:13
Message-ID: Pine.SOL2.3.96.SK.990224155706.10537I-100000@sun.med.ru (view raw or flat)
Thread:
Lists: 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?

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2(at)earthling(dot)net
           Programmers don't die, they just GOSUB without RETURN.


Responses

pgsql-hackers by date

Next:From: Brian P MillettDate: 1999-02-24 14:12:36
Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot
Previous:From: Bruce MomjianDate: 1999-02-24 10:27:07
Subject: Re: [HACKERS] OUTER joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group