Re: Multixacts wraparound monitoring

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Multixacts wraparound monitoring
Дата
Msg-id CAEepm=2hVSb30+K3Z=YhUdtA90P17jhzy3fGfV+Mx-uLmBwS6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multixacts wraparound monitoring  ("Pavlov, Vladimir" <Vladimir.Pavlov@tns-global.ru>)
Список 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 по дате отправления:

Предыдущее
От: Matthew Syphus
Дата:
Сообщение: Re: Create trigger on Materialized View?
Следующее
От: Alexander Reshetov
Дата:
Сообщение: Re: Missed LIMIT clause pushdown in FDW API