From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
Cc: | jdiehl(at)sandia(dot)gov (Diehl Jeffrey), pgsql-sql(at)postgresql(dot)org (''pgsql-sql(at)postgresql(dot)org' ') |
Subject: | Re: Out of free buffers... HELP! |
Date: | 2001-09-18 23:26:16 |
Message-ID: | 26477.1000855576@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
darcy(at)druid(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Brett Schwarz | 2001-09-19 00:28:09 | Re: Holiday Calculations? |
Previous Message | Stephan Szabo | 2001-09-18 23:21:51 | Re: Stored prosedure last run |