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.
Our largest table has 75 million rows and the autoanalyze scale factor is set to 0.05.
The documentation I've read suggests that the analyze always operates on the entire table and is not incremental. Given that supposition are there ways to control cost(especially CPU) of the autoanalyze operation? Would a more aggressive autoanalyze scale factor (0.01) help. With the current scale factor we see an autoanalyze once a week, query performance has been acceptable so far, which could imply that scale factor could be increased if necessary.
Thanks,
Habib Nahas