Received: from smtp-1.attica.net.nz (pop3-1.attica.net.nz [202.180.66.199]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8J5tke59949 for ; Wed, 19 Sep 2001 01:55:47 -0400 (EDT) (envelope-from markir@slingshot.co.nz) Received: (qmail 75304 invoked from network); 19 Sep 2001 05:55:32 -0000 Received: from 202-180-68-41.nas1.wgn.attica.net.nz (HELO spikey.slithery.org) (202.180.68.41) by pop3-1.attica.net.nz with SMTP; 19 Sep 2001 05:55:32 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Mark kirkwood To: "Diehl, Jeffrey" Subject: Re: Out of free buffers... HELP! Date: Wed, 19 Sep 2001 17:55:47 +1200 X-Mailer: KMail [version 1.2] Cc: "''pgsql-sql@postgresql.org' '" MIME-Version: 1.0 Message-Id: <01091917554700.03741@spikey.slithery.org> Content-Transfer-Encoding: 8bit X-Archive-Number: 200109/139 X-Sequence-Number: 4817 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