From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Alessandro Ferraresi <alessandro(dot)ferraresi1(at)gmail(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #16098: unexplained autovacuum to prevent wraparound |
Date: | 2019-12-29 21:17:14 |
Message-ID: | CAMkU=1zbfXMM0oVy_UyQ5_5wCz4fKcnbqvnrj_k8w_hTsBrk_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, Nov 8, 2019 at 2:37 PM Alessandro Ferraresi <
alessandro(dot)ferraresi1(at)gmail(dot)com> wrote:
>
> Autovacuum to prevent wrap around kicks in on those table, I was actually
> wondering if this is somehow related to *autovacuum_multixact_freeze_max_age
> *parameter and how. That behavior should be referred to row locking on
> multiple transaction but this database is still static and not accessible
> yet, meaning there shouldn't be row level concurrency. For completeness,
> the load for each table is executed by 40 parallel sessions running the
> copy command.
>
I would think 40 parallel sessions loading data would exactly trigger
multixact, if you have foreign key constraints in place at the time. Each
parent row has be locked by each parallel session, to make sure the parent
row doesn't go away (or have the key changed) while the child insert is
happening.
Cheers,
Jeff
>
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2019-12-30 05:47:08 | Re: Reorderbuffer crash during recovery |
Previous Message | Jeff Janes | 2019-12-29 16:11:39 | Re: Indexing on JSONB field not working |