Postgres Pro
Downloads
Home   >   mailing lists

work_mem and shared_buffers question - Mailing list pgsql-general

From Ayub M
Subject work_mem and shared_buffers question
Date
Msg-id CAOS0qEvVgiGb45Y7AWiGZ3FAEYu8Ac1G-tMbO2b3Kduk4zaRwQ@mail.gmail.com
Whole thread Raw
Responses Re: work_mem and shared_buffers question  (Naresh g <naresh5310@gmail.com>)
List pgsql-general
Tree view
  1. shared_buffers - In a regular PostgreSQL installation, say I am allocating 25% of my memory to shared_buffers that means it leaves 75% for rest such as OS, page cache and work_mems etc. Is my understanding correct? If so, AWS Aurora for Postgres uses 75% of memory for shared_buffers, then it would leave just 25% for other things?
  2. Does the memory specified for work_mem, fully gets allocated to all sessions irrespective of whether they do any sorting or hashing operations?

--
Regards,
Ayub

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Next
From: Naresh g
Date:
Subject: Re: work_mem and shared_buffers question