Received: from druid.net (druid.net [216.126.72.98]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8IBMZd04725 for ; Tue, 18 Sep 2001 07:22:35 -0400 (EDT) (envelope-from darcy@druid.net) Received: by druid.net (Postfix, from userid 1000) id 2E90F1A6F; Tue, 18 Sep 2001 07:22:36 -0400 (EDT) Subject: Re: Out of free buffers... HELP! To: jdiehl@sandia.gov (Diehl Jeffrey) Date: Tue, 18 Sep 2001 07:22:36 -0400 (EDT) Cc: jdiehl@sandia.gov (Diehl Jeffrey), pgsql-sql@postgresql.org (''pgsql-sql@postgresql.org' ') In-Reply-To: from "Diehl, Jeffrey" at Sep 18, 2001 01:07:47 AM X-Mailer: ELM [version 2.5 PL5] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20010918112236.2E90F1A6F@druid.net> From: darcy@druid.net (D'Arcy J.M. Cain) X-Archive-Number: 200109/125 X-Sequence-Number: 4796 Thus spake Diehl, Jeffrey > I have a large query that I'm trying to run, but it never finishes. I > get an error message and it quits. > > I'm doing: > > psql ids -c 'select src,dst,count(*) from brick* where src_port=135 > group by src,dst' > /tmp/135.dat Hard to tell without knowing more but perhaps you need another table instead of/in addition to this one that just tracks the counts. You can use a trigger to increment it. If you only allow inserts this should be easy. Deletes are easy too. Updates are a little trickier. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.