Search Postgresql Archives

Re: error messages (autovaccum canceled and syntax errors) while loading a DUMP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux