Re: xmin and very high number of concurrent transactions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: xmin and very high number of concurrent transactions
Date
Msg-id 2f281edd-5a4e-c429-8e73-67b4a811baa7@aklaver.com
Whole thread Raw
In response to xmin and very high number of concurrent transactions  (Vijaykumar Jain <vjain@opentable.com>)
Responses Re: [External] Re: xmin and very high number of concurrent transactions  (Vijaykumar Jain <vjain@opentable.com>)
List pgsql-general
On 3/12/19 12:19 PM, Vijaykumar Jain wrote:
> I was asked this question in one of my demos, and it was interesting one.
> 
> we update xmin for new inserts with the current txid.

Why?

> now in a very high concurrent scenario where there are more than 2000
> concurrent users trying to insert new data,
> will updating xmin value be a bottleneck?
> 
> i know we should use pooling solutions to reduce concurrent
> connections but given we have enough resources to take care of
> spawning a new process for a new connection,
> 
> Regards,
> Vijay
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: xmin and very high number of concurrent transactions
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] Re: xmin and very high number of concurrent transactions