Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4ELLXA97190 for ; Mon, 14 May 2001 17:21:35 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 60001) id D37E72AB39; Mon, 14 May 2001 18:21:57 +0300 (GMT) Received: from 170.210.15.78 ( [170.210.15.78]) as user martin@localhost by bugs.unl.edu.ar with HTTP; Mon, 14 May 2001 18:21:56 +0300 Message-ID: <989853716.3afff814ad799@bugs.unl.edu.ar> Date: Mon, 14 May 2001 18:21:56 +0300 From: =?iso-8859-1?B?TWFydO1uIE1hcnF16XM=?= To: Ligia Pimentel Cc: pgsql-sql@postgresql.org Subject: Re: fatal ERROR running simple join query... References: <9dotl7$15vj$1@news.tht.net> In-Reply-To: <9dotl7$15vj$1@news.tht.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs X-Archive-Number: 200105/136 X-Sequence-Number: 2953 Quoting Ligia Pimentel : > > I have a problem with postgres, I'm running a query that joins two tables, > one with 129000+ records, and the other with 1172 records, it's a very > simple join. But postgres can't handle it!!! (Both tables have an index on > the field "cuentacb"). > > I get the following error after 3 minutes... > > migracion=# select * from cuentasequivalentes, equiv11mayo m > migracion-# where cuentasequivalentes.cuentacb = m.cuentacb > migracion-# and cuentasequivalentes.cuentabr <> m.cuentabr; > FATAL 1: Memory exhausted in AllocSetAlloc() > pqReadData() -- backend closed the channel unexpectedly. > This probably means the backend terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Succeeded. First you should run VACUUM analyze on that database, or at least on those 2 tables. Check with EXPLAIN to see how much better the queries get after the analyze. > What can I do? I'm guessing that I could change a configuration parameter > or > something like that, but I don't know. There are so many parameters to change, that I have to tell you to go and see the "PostgreSQL 7.1 Administrator's Guide". Saludos... :-) -- El mejor sistema operativo es aquel que te da de comer. Cuida tu dieta. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------