All autovacuum and deadlock_timeout settings are at their default values
(lines are commented out in postgresql.conf).
Alvaro Herrera wrote:
> 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?
>
>