Thread: ERROR: out of free buffers: time to abort!

ERROR: out of free buffers: time to abort!

From
Dave Smith
Date:
I am running postgres 7.2.4 on SCO Open Server 5.0.4 and am
sporadically seeing these messages in the log. What causes this message
and what do I need to look for in terms of system settings to correct
the problem.

Currently my memory settings are the defaults shipped with postgres.

--
Dave Smith
CANdata Systems Ltd
416-493-9020


Re: ERROR: out of free buffers: time to abort!

From
Jan Wieck
Date:
Dave Smith wrote:

> I am running postgres 7.2.4 on SCO Open Server 5.0.4 and am
> sporadically seeing these messages in the log. What causes this message
> and what do I need to look for in terms of system settings to correct
> the problem.
>
> Currently my memory settings are the defaults shipped with postgres.
>

You have to increase the postgresql.conf parameter shared_buffers. It is
the number of 8k pages held in the shared buffer cache of the
postmaster. Try anything between 512 and 8192 to get started and read on
PostgreSQL performance tuning a little.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #