From: Haller Christoph <ch@rodos.fzk.de>
To: jdiehl@sandia.gov
Cc: pgsql-sql@postgresql.org
Subject: Re: Out of free buffers... HELP!
Date: Tue, 18 Sep 2001 13:17:50 METDST
Message-ID: <200109181117.NAA22493@rodos> (raw)
In-Reply-To: <B51F0C636E578A4E832D3958690CD73E0130C035@es04snlnt>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, jdiehl@sandia.gov
Subject: Re: Out of free buffers... HELP!
In-Reply-To: <200109181117.NAA22493@rodos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox