vacuum is time consuming

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: vacuum is time consuming
Date: 2021-01-28 15:41:43
Message-ID: CA+ONtZ5eU7cD3wqsdPJhmCanvTqJg3rNSQ_piCxszdEwFvjE8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We have DB of 400GBs, Server RAM is 160GBs. CPU consumption is 1-3% only.

We have configured maintenance_work_mem to 10GBs and restarted the
postgres service.

We have done upgrade from postgres 9.5 to 9.6, then when we run vacuum
analyze on database, it is taking more than 5 hours and still running.

Any suggestions for making the process(vacuum analyze) faster are welcome.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2021-01-28 15:42:42 Re: How to post to this mailing list from a web based interface
Previous Message Hemil Ruparel 2021-01-28 15:35:26 Re: How to post to this mailing list from a web based interface