| From: | "Pavlov, Vladimir" <Vladimir(dot)Pavlov(at)tns-global(dot)ru> |
|---|---|
| To: | 'Alvaro Herrera' <alvherre(at)2ndquadrant(dot)com> |
| 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-25 06:54:50 |
| Message-ID: | B38B34EC5621E34DABCE13E8B18936E602DC2C14BE5A@EXSERV.Gallup.tns |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, thank you very much for your help.
Pg_control out in the attachment.
Kind regards,
Vladimir Pavlov
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)2ndquadrant(dot)com]
Sent: Friday, March 25, 2016 12:25 AM
To: Pavlov Vladimir
Cc: 'Adrian Klaver'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Multixacts wraparound monitoring
Pavlov, Vladimir wrote:
> There is nothing:
> select * from pg_prepared_xacts;
> transaction | gid | prepared | owner | database
> -------------+-----+----------+-------+----------
> (0 rows)
> It is also noticed that a lot of files in a directory main/pg_multixact/members/, now - 69640.
Can you attach pg_controldata output?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| pg_control.out | application/octet-stream | 2.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Morgan Lloyd | 2016-03-25 08:37:22 | Re: PostgreSQL advocacy |
| Previous Message | Melvin Davidson | 2016-03-24 22:58:10 | Re: Way to get at parsed trigger 'WHEN' clause expression? |