Postgres Pro
Downloads
Home   >   mailing lists

vacuum is time consuming - Mailing list pgsql-general

From Atul Kumar
Subject vacuum is time consuming
Date
Msg-id CA+ONtZ5eU7cD3wqsdPJhmCanvTqJg3rNSQ_piCxszdEwFvjE8w@mail.gmail.com
Whole thread Raw
Responses Re: vacuum is time consuming
Re: vacuum is time consuming
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Hemil Ruparel
Date:
Subject: Re: How to post to this mailing list from a web based interface
Next
From: Matthias Apitz
Date:
Subject: Re: How to post to this mailing list from a web based interface