Re: Out of free buffers... HELP! - Mailing list pgsql-sql

From Tom Lane
Subject Re: Out of free buffers... HELP!
Date
Msg-id 2974.1020207024@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of free buffers... HELP!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
[ digging through some old email ]

I wrote:
> "Diehl, Jeffrey" <jdiehl@sandia.gov> writes:
>> Brick* implies 1334 tables

> Hmm ... I wonder if the query is somehow holding onto a buffer pin for
> the last block of each successively-accessed table?  Will look into it.

I find that indeed 7.1 and older versions do that, but 7.2 does not
(due to simplifications in heap_getnext).  So this problem should be
gone as of the current release.
        regards, tom lane


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: performance on update table from a join
Next
From: Gary Stainburn
Date:
Subject: problem with update from subselect