Is there a significant difference in Memory settings between 9.5 and 12

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Is there a significant difference in Memory settings between 9.5 and 12
Date: 2020-05-11 20:15:10
Message-ID: CAEaSS0aewdAM5REvG7+5vPWGbxYfCq4KvbUsG6CBjX+0gA8y=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Upgraded from 9.5 to 12 and 12 would not start with the current configured
Shared Buffers.

Same hardware, same config file.

Which tells me something has changed, are there new default settings in the
12 postgresql.conf file that are not being called out in my 9.5 config file
that could be the cause or?

9.5
shared_buffers 10GB

12
shared_buffers 5GB

12 will not start at 10GB, even though it's the same hardware, same config
file, same physical box, same everything, just version 12 vs 9.5

So this tells me that maybe i'm missing a new memory setting in 12 , that
is not being overwritten in my local config file (I run an include and my
own settings), this worked fine in 9.5 but I'm guessing there is something
considerably different between 9.5 and 12 (I'm just not seeing it). Anyone
with insight into what memory settings may have been added in 10/11/12 that
are significantly different than 9.5?

Thanks
Tory

CentOS 7
Postgresql 9.5.x
Postgresql 12.2

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-05-11 20:36:27 Re: Is there a significant difference in Memory settings between 9.5 and 12
Previous Message Matthias Apitz 2020-05-11 20:06:58 Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'