Re: maintenance_work_mem is it per instance or per database??

Hi Pavan,

Go through this link. hope this will help you.
https://www.postgresql.org/docs/current/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY

OR

Architecture and Tuning of Memory in PostgreSQL Databases.
https://severalnines.com/blog/architecture-and-tuning-memory-postgresql-databases

On Fri, Nov 2, 2018 at 9:58 AM pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:

> Hello all,
>
> Is the parameter maintenance_work_mem is per database or per instance??
>
> And while exploring the configuration parameters I'm assuming that the sum
> of values(default values) for the parameters maintenance_work_mem(64MB),
> work_mem(4MB),temp_buffers(8MB), wal_buffers(4MB) will be equal to the
> value
> of shared buffers(128MB).
>
> But the total corresponds to 80MB where is the remaining part of shared
> buffers(48MB) used?? I have read like clog buffers don't have any explicit
> parameter to be set, it is tuned automatically by database engine
>
> So will that remaining will be used by the client requests??
>
> Please clarify me. Thanks in advance!!
>
> Regards,
> Pavan
>
>
>
> --
> Sent from:
> http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
>