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

From Vijaykumar Jain
Subject xmin and very high number of concurrent transactions
Date
Msg-id CAE7uO5hEyOdCGw02j6JqJzZAje2b20kzFco9h3Lwia3ahfivtw@mail.gmail.com
Whole thread Raw
Responses Re: xmin and very high number of concurrent transactions
Re: xmin and very high number of concurrent transactions
Re: xmin and very high number of concurrent transactions
List pgsql-general
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.
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


pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: POSTGRES/MYSQL
Next
From: Adrian Klaver
Date:
Subject: Re: xmin and very high number of concurrent transactions