From: Tom Lane <tgl@sss.pgh.pa.us>
To: darcy@druid.net
Cc: jdiehl@sandia.gov
Cc: pgsql-sql@postgresql.org
Subject: Re: Out of free buffers... HELP!
Date: Tue, 18 Sep 2001 19:26:16 -0400
Message-ID: <26477.1000855576@sss.pgh.pa.us> (raw)
In-Reply-To: <20010918112236.2E90F1A6F@druid.net>
References: <20010918112236.2E90F1A6F@druid.net>
darcy@druid.net (D'Arcy J.M. Cain) writes:
> Thus spake Diehl, Jeffrey
>> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
>> group by src,dst' > /tmp/135.dat
> Hard to tell without knowing more but perhaps you need another table
> instead of/in addition to this one that just tracks the counts. You
> can use a trigger to increment it. If you only allow inserts this
> should be easy. Deletes are easy too. Updates are a little trickier.
The thing is, you shouldn't ever get "out of free buffers", period.
Jeffrey must be running into some kind of buffer-leak bug ... but it's
hard to think what, unless he's running an extremely old PG version.
We haven't seen reports of buffer leaks in a long time. So I'd like
to run that down, quite independently of whether he should change his
query for efficiency.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, darcy@druid.net, jdiehl@sandia.gov
Subject: Re: Out of free buffers... HELP!
In-Reply-To: <26477.1000855576@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox