Re: [External] Re: xmin and very high number of concurrent transactions

2019-03-13 Thread Vijaykumar Jain
Thank you everyone for responding. Appreciate your help. Looks like I need to understand the concepts a little more in detail , to be able to ask the right questions, but atleast now I can look at the relevant docs. On Wed, 13 Mar 2019 at 2:44 PM Julien Rouhaud wrote: > On Wed, Mar 13, 2019 a

Re: [External] Re: xmin and very high number of concurrent transactions

2019-03-12 Thread Adrian Klaver
On 3/12/19 1:02 PM, Vijaykumar Jain wrote: no i mean not we end users, postgres does it (?) via the xmin and xmax fields from inherited tables :) if that is what you wanted in a why or are you asking, does postgres even update those rows and i am wrong assuming it that way? Not sure where the

Re: [External] Re: xmin and very high number of concurrent transactions

2019-03-12 Thread Vijaykumar Jain
no i mean not we end users, postgres does it (?) via the xmin and xmax fields from inherited tables :) if that is what you wanted in a why or are you asking, does postgres even update those rows and i am wrong assuming it that way? since the values need to be atomic, consider the below analogy as