| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Dave Smith <dave(dot)smith(at)candata(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: out of free buffers: time to abort! |
| Date: | 2003-11-11 00:33:24 |
| Message-ID: | 3FB02E54.6070401@Yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-11-11 00:44:25 | Re: PL/Perl returning multiple rows |
| Previous Message | TANIDA Yutaka | 2003-11-11 00:19:16 | Re: Temp rows - is it possible? |