Re: Tunning Server 9.1.

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tunning Server 9.1.
Date: 2016-08-04 06:02:20
Message-ID: 3745aaf6-c1d9-0e1a-9de0-f43fad24562b@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/3/2016 10:13 PM, Periko Support wrote:
> This send me a message about shared_memory need to lower the value
> which default settings = 24MB.

what message was this, exactly ?

on a 128GB ram system, I would probably have shared_buffers up around 4-8GB.

btw, postgres 9.1 is getting on in age, and will soon be desupported,
newer versions no longer used SysV shm, so you no longer need to adjust
shmmax values in your kernel.

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-08-04 06:44:04 Re: [SPAM] Re: [SPAM] Re: WAL directory size calculation
Previous Message John R Pierce 2016-08-04 06:00:05 Re: Question about wal files / pg_xlogs