Postgres Pro
Downloads
Home   >   mailing lists

Different memory allocation strategy in Postgres 11? - Mailing list pgsql-general

From Thomas Kellerer
Subject Different memory allocation strategy in Postgres 11?
Date
Msg-id pqv3nn$55o$1@blaine.gmane.org
Whole thread Raw
Responses Re: Different memory allocation strategy in Postgres 11?
List pgsql-general
Tree view 
I have a Postgres instance running on my Windows laptop for testing purposes. 

I typically configure "shared_buffers = 4096MB" on my 16GB system as sometimes when testing, it pays off to have a
biggercache. 
 

With Postgres 10 and earlier, the Postgres process(es) would only allocate that memory from the operating system when
needed.
 
So right after startup, it would only consume several hundred MB, not the entire 4GB

However with Postgres 11 I noticed that it immediately grabs the complete memory configured for shared_buffers during
startup.

It's not really a big deal, but I wonder if that is an intentional change or a result from something else? 

Regards
Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should pg 11 use a lot more memory building an spgist index?
Next
From: Adrian Klaver
Date:
Subject: Re: ERROR: type "myrowtype" does not exist