Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] ShmemAlloc maximum size - Mailing list pgsql-general

From hari.prasath
Subject Re: [GENERAL] ShmemAlloc maximum size
Date
Msg-id 15a6bb16aa9.cc313c8e49785.6891935989017110154@zohocorp.com
Whole thread Raw
In response to Re: [GENERAL] ShmemAlloc maximum size  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
Tried in 9.5 and 9.6 version if postgresql. 

OS: mac sierra 16gb RAM

cheers
- Harry


---- On Thu, 23 Feb 2017 20:27:58 +0530 Melvin Davidson<melvin6925@gmail.com> wrote ----



On Thu, Feb 23, 2017 at 9:47 AM, hari.prasath <hari.prasath@zohocorp.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 Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: Rob Brucks
Date:
Subject: Re: [GENERAL] NOTIFY command impact