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 -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
