pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (19+ messages)  latest in thread

Message-ID: <26477.1000855576@sss.pgh.pa.us>
Permalink:  ../26477.1000855576@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/26477.1000855576@sss.pgh.pa.us

 · 

reply

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