Re: Running concurrent txns and measuring the timings in Postgres

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Running concurrent txns and measuring the timings in Postgres
Дата
Msg-id 9FDB31EE-CEC5-4B19-B311-E96AC7139706@gmail.com
обсуждение исходный текст
Ответ на Re: Running concurrent txns and measuring the timings in Postgres  (Souvik Bhattacherjee <kivuosb@gmail.com>)
Список pgsql-general

On Jul 24, 2019, at 1:22 PM, Souvik Bhattacherjee <kivuosb@gmail.com> wrote:

> It would help to know what problem you are trying to solve?

Multiple txns are inserting tuples into a table concurrently. Wanted to measure
the total time taken to complete the insertion process. Some txns overlap with
others on the tuples they insert. Duplicate tuples are not inserted.
Start both/all clients at approximately the same time, each firing a transaction at some believable interval. (Or separate threads with separate db connections.)  This should generate the concurrency load I think you’re looking for. You can easily time the iteration; actual details on server side would likely involve turning on maximum logging, with client identifier, and analyzing the logs.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jatinder Sandhu
Дата:
Сообщение: Re: partition table slow planning
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Running concurrent txns and measuring the timings in Postgres