Re: Out of free buffers... HELP!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
Cc: darcy(at)druid(dot)net, pgsql-sql(at)postgresql(dot)org
Subject: Re: Out of free buffers... HELP!
Date: 2001-09-19 23:38:01
Message-ID: 369.1000942681@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Diehl, Jeffrey" <jdiehl(at)sandia(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-09-20 00:35:37 Re: Out of free buffers... HELP!
Previous Message clayton cottingham 2001-09-19 22:39:23 Re: Holiday Calculations?