Re: Out of free buffers... HELP!

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.