Thread: ERROR: out of free buffers: time to abort!
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
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 #