From: | Wyatt Alt <wyatt(dot)alt(at)gmail(dot)com> |
---|---|
To: | bruno da silva <brunogiovs(at)gmail(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Multixact wraparound monitoring |
Date: | 2023-09-14 05:14:28 |
Message-ID: | CAGem3qCO7ny4H96h1Bs3a_3UVGBQCoBQCo5Ds2nR=egO93G-qw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Wed, Sep 13, 2023 at 8:29 AM bruno da silva <brunogiovs(at)gmail(dot)com> wrote:
>
> are foreign keys a big source of multixact IDs so not recommended on
> tables with a lot of data and a lot of churn?
>
I am curious to hear other answers or if anything has changed. I
experienced this problem a couple of times on PG 11. In each situation my
setup looked something like this:
create table small(id int primary key, data text);
create table large(id bigint primary key, small_id int references
small(id));
Table large is hundreds of GB or more and accepting heavy writes in batches
of 1K records, and every batch contains exactly one reference to each row
in small (every batch references the same 1K rows in small).
The only way I was able to get around problems with multixact member ID
wraparound was dropping the foreign key constraint.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2023-09-14 11:23:41 | Re: Multixact wraparound monitoring |
Previous Message | bruno da silva | 2023-09-13 12:21:40 | Multixact wraparound monitoring |