Search Postgresql Archives

Re: Different memory allocation strategy in Postgres 11?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 a bigger cache.

    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?


Do you have pg_prewarm in shared_preload_libraries?

No. The only shared libraries are those for pg_stat_statemens






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux