Re: 24.1.5.1. Multixacts And Wraparound

2021-07-02 Thread Bruce Momjian
On Thu, Jun 24, 2021 at 04:06:38PM -0400, Álvaro Herrera wrote: > On 2021-Jun-24, Bruce Momjian wrote: > > > + As a safety device, an aggressive vacuum scan will > > + occur for any table whose multixact-age (see > + linkend="vacuum-for-multixact-wraparound"/>) is greater than > +

Re: 24.1.5.1. Multixacts And Wraparound

2021-06-24 Thread Alvaro Herrera
On 2021-Jun-24, Bruce Momjian wrote: > + As a safety device, an aggressive vacuum scan will > + occur for any table whose multixact-age (see + linkend="vacuum-for-multixact-wraparound"/>) is greater than + linkend="guc-autovacuum-multixact-freeze-max-age"/>. Also, if the > +

Re: 24.1.5.1. Multixacts And Wraparound

2021-06-24 Thread Bruce Momjian
On Tue, Jun 22, 2021 at 08:32:18AM +0200, Laurenz Albe wrote: > > What does "the amount of used member storage space exceeds 50% of the > > addressable storage space" mean? > > You are right. See MultiXactMemberFreezeThreshold for the whole story. > > What about: > > As a safety device, an

Re: 24.1.5.1. Multixacts And Wraparound

2021-06-22 Thread Laurenz Albe
On Mon, 2021-06-21 at 22:50 -0400, Bruce Momjian wrote: > On Fri, Jun 18, 2021 at 08:51:00AM +0200, Laurenz Albe wrote: > > On Thu, 2021-06-17 at 18:31 +, PG Doc comments form wrote: > > > In section "24.1.5.1. Multixacts And Wraparound" of > > > https://ww

Re: 24.1.5.1. Multixacts And Wraparound

2021-06-21 Thread Bruce Momjian
On Fri, Jun 18, 2021 at 08:51:00AM +0200, Laurenz Albe wrote: > On Thu, 2021-06-17 at 18:31 +, PG Doc comments form wrote: > > In section "24.1.5.1. Multixacts And Wraparound" of > > https://www.postgresql.org/docs/current/routine-vacuuming.html we find the >

Re: 24.1.5.1. Multixacts And Wraparound

2021-06-18 Thread Laurenz Albe
On Thu, 2021-06-17 at 18:31 +, PG Doc comments form wrote: > In section "24.1.5.1. Multixacts And Wraparound" of > https://www.postgresql.org/docs/current/routine-vacuuming.html we find the > following sentence towards the end of the section: > > "...If the amoun

24.1.5.1. Multixacts And Wraparound

2021-06-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/routine-vacuuming.html Description: In section "24.1.5.1. Multixacts And Wraparound" of https://www.postgresql.org/docs/current/routine-vacuuming.html we find the followin