Re: Size of pg_multixact/members increases 11355

2017-12-18 Thread Yogesh Sharma
Dear All, I have upgraded version from 9.3.6 to 9.3.20 but this issue is not resolved. can you please suggest in which version this file size are not increased. Regards, Yogesh On Thursday, December 14, 2017, Alvaro Herrera wrote: > Yogesh Sharma wrote: > > Dear Thomas , > > > > Thanks for sh

Re: Size of pg_multixact/members increases 11355

2017-12-14 Thread Alvaro Herrera
Yogesh Sharma wrote: > Dear Thomas , > > Thanks for sharing information. > > Is it possible to remove mentioned folder files in some time intervals by > some DB command? > Currently i can not upgrade to 3.6.20. > So please share if any solution is available. If you do not upgrade, you risk getti

Re: Size of pg_multixact/members increases 11355

2017-12-13 Thread Yogesh Sharma
Dear Thomas, Thanks for your updation. I have also checked on older version 8.1.3. In older version , after 32 MB folder size increased, it automatically cleaned files and size is reduced. This size is dependent on which paramter in older version? Regards, Yogesh On Wednesday, December 13, 201

Re: Size of pg_multixact/members increases 11355

2017-12-13 Thread Tomas Vondra
On 12/13/2017 01:42 PM, Yogesh Sharma wrote: > Dear Thomas , > > Thanks for sharing information. > > Is it possible to remove mentioned folder files in some time intervals > by some DB command? > Currently i can not upgrade to 3.6.20. > So please share if any solution is available. > There ar

Re: Size of pg_multixact/members increases 11355

2017-12-13 Thread Yogesh Sharma
Dear Thomas , Thanks for sharing information. Is it possible to remove mentioned folder files in some time intervals by some DB command? Currently i can not upgrade to 3.6.20. So please share if any solution is available. Regards, Yogesh On Wednesday, December 13, 2017, Yogesh Sharma wrote: >

Re: Size of pg_multixact/members increases 11355

2017-12-12 Thread Yogesh Sharma
Dear Thomas and All, Thanks for sharing your input. How we calculate autovacuum_multixact_freeze_max_age paramter limit into system? Regards, Yogesh On Wednesday, December 13, 2017, Thomas Munro wrote: > On Wed, Dec 13, 2017 at 5:05 AM, David G. Johnston > wrote: > > On Tue, Dec 12, 2017 at 2

Re: Size of pg_multixact/members increases 11355

2017-12-12 Thread Thomas Munro
On Wed, Dec 13, 2017 at 5:05 AM, David G. Johnston wrote: > On Tue, Dec 12, 2017 at 2:52 AM, Yogesh Sharma > wrote: >> >> Dear All, >> >> I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder >> size is increased to around 3GB. How to reduce this folder size and how to >> fi

Re: Size of pg_multixact/members increases 11355

2017-12-12 Thread David G. Johnston
On Tue, Dec 12, 2017 at 2:52 AM, Yogesh Sharma wrote: > Dear All, > > I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder > size is increased to around 3GB. How to reduce this folder size and how to > fix this issue? > Is it realted to poatgres issue? If yes how to reprodu

Re: Size of pg_multixact/members increases 11355

2017-12-12 Thread Yogesh Sharma
Please share direction to resolve below issue. Regards, Yogesh On Tuesday, December 12, 2017, Yogesh Sharma wrote: > Dear All, > > I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder > size is increased to around 3GB. How to reduce this folder size and how to > fix this

Size of pg_multixact/members increases 11355

2017-12-12 Thread Yogesh Sharma
Dear All, I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder size is increased to around 3GB. How to reduce this folder size and how to fix this issue? Is it realted to poatgres issue? If yes how to reproduce this issue? Thanks in advance. Regards, Yogesh