Re: ShmemAlloc maximum size

Tried in 9.5 and 9.6 version if postgresql. OS: mac sierra 16gb RAMcheers- Harry---- On Thu, 23 Feb 2017 20:27:58 +0530 Melvin Davidson<melvin6925(at)gmail(dot)com> wrote ----On Thu, Feb 23, 2017 at 9:47 AM, hari.prasath <hari(dot)prasath(at)zohocorp(dot)com> wrote:I am trying to get some 15MB of shared memory using ShmemAlloc. Cross checked all my kernal variables set in OS level and also in postgresql.conf.Cant able to get the required memory(15MB) but if i try with some small memory(1MB), its working fine. Am i missing something.? cheers- Harry>Am i missing something.? Probably. Perhaps if you told us the exact version of PostgreSQL & O/S, it might be more helpful.-- Melvin DavidsonI reserve the right to fantasize.  Whether or not you wish to share my fantasy is entirely up to you.