Re: [GENERAL] pg_multixact issues

2016-02-11 Thread Achilleas Mantzios
Καλημέρα Κυριάκο We have been running 9.3.4 as our test system for quite some years, and 9.3.10 on production for a month or so (little less than 1T size, WAL changes worth of 2-5GB/day, about 250K xations/day) we never experienced any problems with data/pg_multixact. In our 9.3.4 : %

[GENERAL] pg_multixact issues

2016-02-10 Thread Kiriakos Georgiou
Hello, Our pg_multixact directory keeps growing. I did a "vacuum freeze” which didn’t help. I also did a "vacuum full” which didn’t help either. We had this condition with 9.3.4 as well. When I upgraded our cluster to 9.4.5 (via plain sql dump and load) as expected the issue was resolved but

Re: [GENERAL] pg_multixact issues

2016-02-10 Thread Thomas Munro
On Thu, Feb 11, 2016 at 7:52 AM, Kiriakos Georgiou wrote: > Hello, > > Our pg_multixact directory keeps growing. I did a "vacuum freeze” which > didn’t help. I also did a "vacuum full” which didn’t help either. > We had this condition with 9.3.4 as well. When I

Re: [GENERAL] pg_multixact issues

2016-02-10 Thread Alvaro Herrera
Thomas Munro wrote: > 4. You could look into whether all those multixacts with many member > are really expected. (Large numbers of concurrent FK checks or > explicit share locks on the same rows perhaps? A good proportion of > this happened on one day this week I see.) I think maybe this

Re: [GENERAL] pg_multixact issues

2016-02-10 Thread Thomas Munro
On Thu, Feb 11, 2016 at 11:05 AM, Alvaro Herrera wrote: > Thomas Munro wrote: > >> 4. You could look into whether all those multixacts with many member >> are really expected. (Large numbers of concurrent FK checks or >> explicit share locks on the same rows perhaps?

Re: [GENERAL] pg_multixact issues

2014-09-19 Thread Emanuel Calvo
El 17/09/14 10:51, Dev Kumkar escribió: On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund and...@2ndquadrant.com mailto:and...@2ndquadrant.com wrote: On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: On one my machine the pg_multixact directory size has grown up to 5 GB and am

Re: [GENERAL] pg_multixact issues

2014-09-19 Thread Dev Kumkar
On Fri, Sep 19, 2014 at 7:14 PM, Emanuel Calvo emanuel.ca...@2ndquadrant.com wrote: Could it be related to some fixes on 9.3.5?: - Fix wraparound handling for pg_multixact/members (Álvaro Herrera) - Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro Herrera) Currently

[GENERAL] pg_multixact issues

2014-09-17 Thread Dev Kumkar
Hello, On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory. From the storage-file-layout this directory contains multitransaction status data. pg_multixactSubdirectory containing multitransaction status data (used for shared row

Re: [GENERAL] pg_multixact issues

2014-09-17 Thread Andres Freund
On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory. Which version of postgres are you using? Greetings, Andres Freund -- Andres Freund

Re: [GENERAL] pg_multixact issues

2014-09-17 Thread Dev Kumkar
On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund and...@2ndquadrant.com wrote: On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory. Which version of postgres are you using?