Out of free buffers... HELP!

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Out of free buffers... HELP!
Date: 2001-09-17 15:36:57
Message-ID: B51F0C636E578A4E832D3958690CD73E0130C028@es04snlnt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message rdear 2001-09-17 15:41:22 PL/PGSQL Regexe
Previous Message Josh Berkus 2001-09-17 15:27:31 Re: I could do with some guidance