mp of pg_top would have been very
helpful here.
-Habib
On Tue, Dec 19, 2017 at 11:15 PM, Laurenz Albe
wrote:
> Habib Nahas wrote:
> > The CPU spike occurred between 13:05 - 13:15. last_autoanalyze for the
> table
> > shows a time of 12:49; last_autovacuum does not show any activi
other causes
are ruled out.
Thanks
On Tue, Dec 19, 2017 at 2:03 PM, Tomas Vondra
wrote:
>
>
> On 12/19/2017 05:47 PM, Habib Nahas wrote:
> > Hi,
> >
> > We operate an RDS postgres 9.5 instance and have periodic CPU spikes to
> > 100%. These spikes appear to be du
determine effect on db we may end up doing that.
- We have an open schema and heavily depend on jsonb, so I'm not sure if
increasing the statistics target will be helpful.
Thanks
On Tue, Dec 19, 2017 at 2:03 PM, Tomas Vondra
wrote:
>
>
> On 12/19/2017 05:47 PM, Habib Nahas wrote:
>
query performance has been
acceptable so far, which could imply that scale factor could be increased
if necessary.
Thanks,
Habib Nahas
