# Postgre-SQL shared buffer unable to increase

**URL:** <https://forums.percona.com/t/postgre-sql-shared-buffer-unable-to-increase/26373>\
**Category:** PostgreSQL\
**Tags:** postgres\
**Created:** [November 6, 2023, 7:28am UTC](https://forums.percona.com/t/postgre-sql-shared-buffer-unable-to-increase/26373 "2023-11-06T07:28:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Basavaraj\_Negalur](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/basavaraj_negalur/32/13572_2.png) [@Basavaraj\_Negalur](https://forums.percona.com/u/Basavaraj_Negalur)\
**Post date:** [November 6, 2023, 7:28am UTC](https://forums.percona.com/t/postgre-sql-shared-buffer-unable-to-increase/26373/1 "2023-11-06T07:28:11Z")

</div>

Hi Team,  
Unable to increase shared buffer above 8GB in postgresql 12 DB where we have enough memory on OS and we tried to tune SHMALL and SHMMAX on OS but no luck!  
Please suggest .

2023-11-03 13:58:00.159 IST [1773535] FATAL: could not map anonymous shared memory: Cannot allocate memory  
2023-11-03 13:58:00.159 IST [1773535] HINT: This error usually means that PostgreSQL’s request for a shared memory segment exceeded available memory, swap space, or huge pages. To reduce the request size (currently 35214278656 bytes), reduce PostgreSQL’s shared memory usage, perhaps by reducing shared\_buffers or max\_connections.  
2023-11-03 13:58:00.159 IST [1773535] LOG: database system is shut down

Regards,  
Basavaraj

---

<div class="post-metadata">

**Author:** ![Shivam\_Dhapatkar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shivam_dhapatkar/32/8774_2.png) [@Shivam\_Dhapatkar](https://forums.percona.com/u/Shivam_Dhapatkar)\
**Post date:** [December 4, 2023, 6:46am UTC](https://forums.percona.com/t/postgre-sql-shared-buffer-unable-to-increase/26373/2 "2023-12-04T06:46:45Z")

</div>

Hello Basavraj,  
Can you share the output of the below Postgres commands and `free -g` output from the O.S level to troubleshoot your issue further?

```auto
show shared_buffers;
show max_connections;
show work_mem;

```

Thanks.
