El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió: > > 2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task > > 2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table "testdump.public.idm_tasktab" > > > From what I understand they are occurring because the machine is to busy > doing the restore to get to the autovacuum task in a timely manner. So I > would say ignore and check back later to see that the autovacuum is working. > Given that it is ANALYZE that is being cancelled I would run a manual > ANALYZE after the restore is done to update the database statistics. The machine is a development server and no one was working on it (today is Saturday) apart of me. It has 4 modern and fast CPU, Running ANALYZE VERBOSE does not give any unusual output. Only for each table lines like: ... INFO: analyzing "public.z39t_term" INFO: "z39t_term": scanned 2 of 2 pages, containing 135 live rows and 0 dead rows; 135 rows in sample, 135 estimated total rows INFO: analyzing "public.z39t_trunc" INFO: "z39t_trunc": scanned 1 of 1 pages, containing 135 live rows and 0 dead rows; 135 rows in sample, 135 estimated total rows ... How could I check that the autovacuum is working? Thanks matthias -- Matthias Apitz, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!
