Re: Autoanalyze CPU usage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Autoanalyze CPU usage
From: Nikolay Samokhvalov <samokhvalov@xxxxxxxxx>
Date: Wed, 20 Dec 2017 11:24:09 +0300
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAE1bBP4vxmMxtC0w37OhDv36M9f8222AbXfy0LWnynWf88ZS-Q@mail.gmail.com>
References: <CAE1bBP4vxmMxtC0w37OhDv36M9f8222AbXfy0LWnynWf88ZS-Q@mail.gmail.com>

On Tue, Dec 19, 2017 at 7:47 PM, Habib Nahas <habibnahas@xxxxxxxxx> wrote:

Hi,

We operate an RDS postgres 9.5 instance and have periodic CPU spikes to 100%. These spikes appear to be due to autoanalyze kicking on our larger tables.

How did you draw such conclusion? How did you find that autoanalyze is the reason of CPU spikes?

References:
- Autoanalyze CPU usage
  - From: Habib Nahas

Prev by Date: Re: Autoanalyze CPU usage
Next by Date: Re: Autoanalyze CPU usage
Previous by thread: Re: Autoanalyze CPU usage
Next by thread: Updating a large table
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux