Re: Out of free buffers... HELP!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
Cc: "''pgsql-sql(at)postgresql(dot)org' '" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Out of free buffers... HELP!
Date: 2001-09-18 13:45:10
Message-ID: 23865.1000820710@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov> writes:
> 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 !

Oh? What PG version is this? What is the schema you are actually
working with --- how many tables are implied by "brick*", for example?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kovacs Baldvin 2001-09-18 14:41:30 Re: Checking for table existence
Previous Message Haller Christoph 2001-09-18 13:17:50 Re: Out of free buffers... HELP!