Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8IBIDd03553 for ; Tue, 18 Sep 2001 07:18:13 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id NAA23624; Tue, 18 Sep 2001 13:18:34 +0200 (METDST) From: Haller Christoph Message-Id: <200109181117.NAA22493@rodos> Subject: Re: Out of free buffers... HELP! To: jdiehl@sandia.gov (Diehl, Jeffrey) Date: Tue, 18 Sep 2001 13:17:50 METDST Cc: pgsql-sql@postgresql.org In-Reply-To: ; from "Diehl, Jeffrey" at Sep 18, 101 10:53 am X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200109/124 X-Sequence-Number: 4795 As long as there are no nulls allowed in column 'dst' the select src,dst,count(dst) from ... should retrieve the same result. Try it. It should run faster anyway. Maybe there are other ways to word your query, but without more knowledge about your table structure and intentions I can't tell you what. Alternatively, you may want to report your error to the [HACKERS] mailing list - there you might even find more detailed support. Regards, Christoph > > Hi all. > > I sent this once before, but didn't see it appear on the list... So here we > go again... > > 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 > > and I get: > > ERROR: out of free buffers: time to abort ! > > Any ideas on how to get this query to run? > > Thanx, > Mike Diehl. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >