Well, basically I'm trying to tune it because the table still keep growing. I thought that by setting the scale and the threshold it will be enough but its seems that it wasnt. I attached some of the logs output to hear what you guys think about it ..
בתאריך יום ד׳, 6 בפבר׳ 2019 ב-16:12 מאת Jeff Janes <jeff.janes@xxxxxxxxx>:
On Wed, Feb 6, 2019 at 5:29 AM Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote:Now the question is how to handle or tune it ? Is there any change that I need to increase the cost_limit / cost_delay ?Sometimes vacuum has more work to do, so it takes more time to do it.There is no indication of a problem. Or at least, you haven't described one. So, there is nothing to handle or to tune.If there is a problem, those log entries might help identify it. But in the absence of a problem, they are just log spam.Cheers,Jeff
