Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Out of free buffers... HELP!
Date
Msg-id 23865.1000820710@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of free buffers... HELP!  ("Diehl, Jeffrey" <jdiehl@sandia.gov>)
List pgsql-sql
Tree view 
"Diehl, Jeffrey" <jdiehl@sandia.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of free buffers... HELP!
Next
From: Miguel González
Date:
Subject: Registring a C function in PostgreSQL