Re: Multixacts wraparound monitoring - Mailing list pgsql-general

From Thomas Munro
Subject Re: Multixacts wraparound monitoring
Date
Msg-id CAEepm=2hVSb30+K3Z=YhUdtA90P17jhzy3fGfV+Mx-uLmBwS6Q@mail.gmail.com
Whole thread Raw
In response to Re: Multixacts wraparound monitoring  ("Pavlov, Vladimir" <Vladimir.Pavlov@tns-global.ru>)
List pgsql-general
On Fri, Apr 1, 2016 at 4:31 AM, Pavlov, Vladimir
<Vladimir.Pavlov@tns-global.ru> wrote:
> I understand correctly, that number of members cannot be more than 2^32 (also uses a 32-bit counter)?

Correct.

> I had 69640 files in main/pg_multixact/members/, 69640*32*2045 = 4557241600 members, this is normal?

Where did you get 2045 from?  I thought it was like this:

number of members = number of member segment files * 1636 * 32
number of multixacts = number of offsets segment files * 2048 * 32

--
Thomas Munro
http://www.enterprisedb.com


pgsql-general by date:

Previous
From: Matthew Syphus
Date:
Subject: Re: Create trigger on Materialized View?
Next
From: Alexander Reshetov
Date:
Subject: Re: Missed LIMIT clause pushdown in FDW API