Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze - Mailing list pgsql-bugs

Jerry Gamache wrote:

> The restore resumed while I was writing this report, and I saw these new
> entries in the logs:
>
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "database1.public.table_y"
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "database1.public.table_y"

This is what I would have expected to happen almost immediately ... what
are your autovacuum settings?  And what's your deadlock timeout?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support