| From: | Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | autovacuum_work_mem and maintenance_work_mem |
| Date: | 2020-12-03 19:41:58 |
| Message-ID: | CAJP2v3GcZNaS0Xy_jxbRv1fmGj-HBk6HN2uNyFOrpe=kh0pSrw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe TD Vo | 2020-12-03 20:51:29 | deactivate user accounts not used within the last 90 days. |
| Previous Message | Rui DeSousa | 2020-12-03 18:45:33 | Re: time taking deletion on large tables |