Re: PGSQL 11.4: shared_buffers and /dev/shm size

From: Jean Louis <bugs(at)gnu(dot)support>
To: Konstantin Malanchev <hombit(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PGSQL 11.4: shared_buffers and /dev/shm size
Date: 2019-07-09 10:15:15
Message-ID: 20190709101514.GB10233@protected.rcdrun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Konstantin Malanchev <hombit(at)gmail(dot)com> [2019-07-09 12:10]:
> Hello Jean,
>
> I have 8 GB RAM and /dev/shm size is 4GB, and there is no significant memory usage by other system processes. I surprised that Postgres uses more space in /dev/shm than sharred_buffers parameter allows, probably I don't understand what this parameter means.
>
> I have no opportunity to enlarge total RAM and probably this query requires too much RAM to execute. Should Postgres just use HDD as temporary storage in this case?

That I cannot know. I know that /dev/shm could
grow as much as available free RAM.

Jean

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2019-07-09 10:51:51 Re: PGSQL 11.4: shared_buffers and /dev/shm size
Previous Message Konstantin Malanchev 2019-07-09 10:09:26 Re: PGSQL 11.4: shared_buffers and /dev/shm size