Received: from email.maxinter.net (mail.lbsnetwork.com [209.25.8.7] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id EAA93758 for ; Fri, 10 Sep 1999 04:28:50 -0400 (EDT) (envelope-from pete@piedmontdata.com) Received: from piedmontdata.com [209.25.89.199] by email.maxinter.net with ESMTP (SMTPD32-5.05) id A2D5FE710054; Fri, 10 Sep 1999 04:35:33 -0400 Message-ID: <37D8C13A.53DC5B8B@piedmontdata.com> Date: Fri, 10 Sep 1999 04:28:43 -0400 From: Peter Andrews X-Mailer: Mozilla 4.61 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: runaway backend process Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Any help with this problem would be greatly appreciated. After executing the following query, the postgres backend server process that is executing the query grows in size until it consumes well over 200 MB and takes several minutes to finish: select mlno from table where (area='01' and sub_area='01') or (area='01' and sub_area='02') or (area='01' and sub_area='03') or (area='01' and sub_area='04') or (area='07' and sub_area='01') or (area='07' and sub_area='02') or (area='07' and sub_area='03') or (area='08' and sub_area='01') or (area='08' and sub_area='03') or (area='09' and sub_area='01') or (area='09' and sub_area='02') or (area='04') or (area='05') or (area='06') or (area='99'); A similar query with fewer terms does not cause an abnormal increase in backend process size, and executes in under a second. Does anyone have any suggestions as to what might be causing this behavior? Redhat 5.2 PostgreSQL 6.5.1 196MB RAM database has been vacuum analyzed table contains ~ 10000 rows Peter Andrews