Re: Out of free buffers... HELP!

From: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
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-19 05:55:47
Message-ID: 01091917554700.03741@spikey.slithery.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-19 08:09:20 Re: Registring a C function in PostgreSQL
Previous Message Peter 2001-09-19 00:50:33 PHP session issue