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

From Tom Lane
Subject Re: Out of free buffers... HELP!
Date
Msg-id 369.1000942681@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of free buffers... HELP!  ("Diehl, Jeffrey" <jdiehl@sandia.gov>)
Responses Re: Out of free buffers... HELP!
List pgsql-sql
"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.

What -B (# of shared buffers) setting are you running the postmaster
with?  Try setting it to 1500 or more, if it's not already.
        regards, tom lane


pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: Re: Holiday Calculations?
Next
From: "Josh Berkus"
Date:
Subject: Re: Out of free buffers... HELP!