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

From Thomas Kellerer
Subject Re: Different memory allocation strategy in Postgres 11?
Date
Msg-id 06c3eb1f-4317-4c61-1038-fbc5ec76b0fa@gmx.net
Whole thread Raw
In response to Re: Different memory allocation strategy in Postgres 11?  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Different memory allocation strategy in Postgres 11?  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-general
Jeff Janes schrieb am 26.10.2018 um 17:42:
>     I typically configure "shared_buffers = 4096MB" on my 16GB system as sometimes when testing, it pays off to have
abigger cache.
 
> 
>     With Postgres 10 and earlier, the Postgres process(es) would only allocate that memory from the operating system
whenneeded.
 
>     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
duringstartup.
 
> 
>     It's not really a big deal, but I wonder if that is an intentional change or a result from something else?
> 
> 
> Do you have pg_prewarm in shared_preload_libraries?

No. The only shared libraries are those for pg_stat_statemens




pgsql-general by date:

Previous
From: Ozz Nixon
Date:
Subject: Re: GIN Index for low cardinality
Next
From: Igor Neyman
Date:
Subject: RE: GIN Index for low cardinality