| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Pavlov, Vladimir" <Vladimir(dot)Pavlov(at)tns-global(dot)ru> |
| Cc: | 'Adrian Klaver' <adrian(dot)klaver(at)aklaver(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Multixacts wraparound monitoring |
| Date: | 2016-03-31 13:16:46 |
| Message-ID: | 20160331131646.GA98919@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Pavlov, Vladimir wrote:
> Hello,
> If I get you right:
> Latest checkpoint's NextMultiXactId: 2075246000
> Latest checkpoint's oldestMultiXid: 2019511697
> Number of members files: 10820
> Size pg_multixact/members/ (bytes) (2.7Gb): 2887696384
> Pages in file: 32
> Members on page: 2045
> Number of members (32*2045*10820): 708060800
> Members per multixact (2075246000 - 2019511697)/708060800: 12,70421916
> Multixact size (bytes) (2887696384/708060800): 4,078316981 - It's a lot?
Yeah, 12.7 members per multixact on average is a lot, unless you have 12
processes concurrently locking the same tuples, all the time (although
that is possible). My guess is that this is related to subtransactions
(either explicit SAVEPOINTs in your SQL code, or EXCEPTION blocks in
plpgsql functions).
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nik Mitev | 2016-03-31 13:24:49 | Re: Is it possible to delete a single value from an enum type? |
| Previous Message | Sándor Daku | 2016-03-31 13:14:55 | Re: Is it possible to delete a single value from an enum type? |