Re: Out of free buffers... HELP!

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>, "''pgsql-sql(at)postgresql(dot)org' '" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Out of free buffers... HELP!
Date: 2001-09-18 07:07:47
Message-ID: B51F0C636E578A4E832D3958690CD73E0130C035@es04snlnt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Haller Christoph 2001-09-18 11:19:08 Re: How to see the definition of an existing table?
Previous Message Josh Berkus 2001-09-18 03:54:23 Re: Checking for table existence