Received: from ural2.hszk.bme.hu (ural2.hszk.bme.hu [152.66.130.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8J0cwd20080 for ; Tue, 18 Sep 2001 20:38:58 -0400 (EDT) (envelope-from kb136@hszk.bme.hu) Received: (from kb136@localhost) by ural2.hszk.bme.hu (8.11.3/8.11.3) id f8IEjXB05148; Tue, 18 Sep 2001 16:45:33 +0200 (MEST) Date: Tue, 18 Sep 2001 16:45:33 +0200 (MEST) From: Kovacs Baldvin X-X-Sender: To: "Diehl, Jeffrey" cc: "''pgsql-sql@postgresql.org' '" Subject: Re: Out of free buffers... HELP! In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by postgresql.org id f8J0cxd20081 X-Archive-Number: 200109/135 X-Sequence-Number: 4813 > 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 ! Does anybody knows if the buffers of pgsql are insufficient, or the operating system cries out this error? Regards, Baldvin > > 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 > Üdv, Baldvin