Postgres Pro
Downloads
Home   >   mailing lists

autovacuum_work_mem and maintenance_work_mem - Mailing list pgsql-admin

From Henry Francisco Garcia Cortez
Subject autovacuum_work_mem and maintenance_work_mem
Date
Msg-id CAJP2v3GcZNaS0Xy_jxbRv1fmGj-HBk6HN2uNyFOrpe=kh0pSrw@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
for default autovacuum_work_mem used the amount of memory RAM from maintenance_work_mem but what will happen if decide to increase the amount of memory RAM on autovacuum_work_mem for instance on 2GB , maintenance_work_mem has 1GB memory RAM and my server has 16GB memory RAM, I ask if it's good idea  that autovacuum_work_mem will use memory RAM independent to maintenance_work_me.

--
Ing. Henry G. Cortez



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: time taking deletion on large tables
Next
From: Pepe TD Vo
Date:
Subject: deactivate user accounts not used within the last 90 days.