Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

2018-02-14 Thread Yogesh Sharma
Dear David, > > > Thanks for update. > I have also checked in postgres 9.3.21 and 9.5.x version. But this is same > as 9.3.6 postres version. > Some one please let me know below points. It will really helpful to > understand postgres behavior. > 1. When this folder pg_multixact/members folder size

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

2018-02-14 Thread Yogesh Sharma
Dear David, Thanks for update. I have also checked in postgres 9.3.21 and 9.5.x version. But this is same as 9.3.6 postres version. Regards, Yogesh On Wednesday, February 14, 2018, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma > wrote

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

2018-02-14 Thread David G. Johnston
On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma wrote: > I am using postgres 9.3.6 version and i am using multiple INSERT/UPDATE > SQL commands with explicit share lock. > ​[...]​ > 4. I Want older postgres behavior in newer versions. So how to set this > behavior through postgres parameters? >

Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

2018-02-14 Thread Yogesh Sharma
Dear All, Thanks for your support and guidance. I am using postgres 9.3.6 version and i am using multiple INSERT/UPDATE SQL commands with explicit share lock. I know pg_multixact/members folder contains transactions of share lock. But these files are continuously increases. I have checked Postgre