xmin and very high number of concurrent transactions

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема xmin and very high number of concurrent transactions
Дата
Msg-id CAE7uO5hEyOdCGw02j6JqJzZAje2b20kzFco9h3Lwia3ahfivtw@mail.gmail.com
обсуждение исходный текст
Ответы 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
Список 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 по дате отправления: