Hello!
We have a situation when after creation of new materialized view cpu
utilization falls down (from about 50% to about 30%), at the same time we have
a cron job, which does refresh of old materialized view, but it does no effect
at performance.
Can anyone explain why is it so? And what is
On 10/31/2016 08:19 PM, Andre Henry wrote:
My PG 9.4.5 server runs on Amazon RDS some times of the day we have a
lot of checkpoints really close (less than 1 minute apart, see logs
below) and we are trying to tune the DB to minimize the impact of the
checkpoint or reduce the number of checkpoints
