Hello, There is no news? Now I have to do VACUUM every night, so that the server worked. Maybe run VACUUM FREEZE? Kind regards, Vladimir Pavlov -----Original Message----- From: Pavlov Vladimir Sent: Friday, March 25, 2016 9:55 AM To: 'Alvaro Herrera' Cc: 'Adrian Klaver'; pgsql-general@xxxxxxxxxxxxxx Subject: RE: Multixacts wraparound monitoring 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@xxxxxxxxxxxxxxx] Sent: Friday, March 25, 2016 12:25 AM To: Pavlov Vladimir Cc: 'Adrian Klaver'; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
