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.ja...@gmail.com>: > On Wed, Feb 6, 2019 at 5:29 AM Mariel Cherkassky < > mariel.cherkas...@gmail.com> 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 >
