pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> 




view thread (19+ messages)  latest in thread

Message-ID: <200109181117.NAA22493@rodos>
Permalink:  ../200109181117.NAA22493@rodos/
Also on:    postgresql.org/message-id/200109181117.NAA22493@rodos

 · 

reply

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