I guess the Htop captured by you is for a particular instant. You will have to record the cpu utilisation for a longer duration and then analyze.
Deepak
On Fri, Jun 8, 2018 at 12:58 PM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
On 06/08/2018 02:24 AM, Owayss Kabtoul wrote:
Hi folks,
I ran into an issue where, on Postgres instances that have a very large number of databases per cluster (~15K), the
I won't ask why there's a cluster with 15,000 databases...
So auto-vacuum never really sleeps. Even changing the autovacuum_naptime and setting it to a much higher value (from 1min to 50min) did not have any effect at all. Both strace and the postgres logs showed a similar behaviour: lots of reads to global.stat file and constantly iterating through all the databases non-stop and executing autovacuum.
Is there anything that I can do to minimize the CPU load impact that this process is having?
What if you disable autovacuum and run it manually?
--
Angular momentum makes the world go 'round.
Deepak
"The greatness of a nation can be judged by the way its animals are treated. Please consider stopping the cruelty by becoming a Vegan"
+91 73500 12833
deicool@xxxxxxxxx
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
deicool@xxxxxxxxx
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
