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

From: Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.
Date: 2018-02-15 01:20:54
Message-ID: CAEZUwCQKz_2PNf0pxQXk91G_s4yN3q4_oaMz6FKd6CCphSBnAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 will cleanup?
> 2. How can i identify that at that time it will start cleanup?
> 3. Does it depends on some postgres config parameters? What is config
> parameters and what will be value of that parameter?
> 4. I Want older postgres behavior in newer versions. So how to set this
> behavior through postgres parameters?
>
>
> Regards,
> Yogesh
>
> On Wednesday, February 14, 2018, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
>> 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?
>>>
>>
>> ​You need to upgrade to 9.3.21. Also, given the issues surrounding early
>> 9.3 releases, did this cluster/database begin its life at 9.3.6 or was
>> there an upgrade path to get there?
>>
>> I don't know whether this is configurable but I would suspect not - your
>> likely issue is software bugs that have since been fixed in one or more of
>> the 15 releases since 9.3.6
>>
>> David J.
>>
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Hanson 2018-02-15 03:46:53 Re: I do not get the point of the information_schema
Previous Message Yogesh Sharma 2018-02-15 01:19:25 Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.