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

From Mark kirkwood
Subject Re: Out of free buffers... HELP!
Date
Msg-id 01091917554700.03741@spikey.slithery.org
Whole thread Raw
In response to Out of free buffers... HELP!  ("Diehl, Jeffrey" <jdiehl@sandia.gov>)
List pgsql-sql
Previously:
>psql ids -c 'select src,dst,count(*) from brick* where src_port=135
>group by src,dst' > /tmp/135.dat

This is just a guess, increasing the parameters shared_buffers and sort_mem 
might help. 

For example if your table is about 1Gb in size then try shared_buffers=10000 
and sort_mem=20000 ( you need an extra 100Mb ram for this )

Cheers

Mark


pgsql-sql by date:

Previous
From: Brett Schwarz
Date:
Subject: Re: Holiday Calculations?
Next
From: Peter Eisentraut
Date:
Subject: Re: Registring a C function in PostgreSQL