Out of free buffers... HELP! - Mailing list pgsql-sql

From Diehl, Jeffrey
Subject Out of free buffers... HELP!
Date
Msg-id B51F0C636E578A4E832D3958690CD73E0130C028@es04snlnt
Whole thread Raw
List pgsql-sql
Hi all.

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.



pgsql-sql by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: Number the lines
Next
From: Hans-Juergen Schoenig
Date:
Subject: Re: How to Get Timestamp From SECONDS?