Re: Running concurrent txns and measuring the timings in Postgres

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Running concurrent txns and measuring the timings in Postgres
Дата
Msg-id 160cb824-6952-d468-9a6b-3b7474348d5a@aklaver.com
обсуждение исходный текст
Ответ на Running concurrent txns and measuring the timings in Postgres  (Souvik Bhattacherjee <kivuosb@gmail.com>)
Ответы Re: Running concurrent txns and measuring the timings in Postgres  (Souvik Bhattacherjee <kivuosb@gmail.com>)
Список pgsql-general
On 7/24/19 9:54 AM, Souvik Bhattacherjee wrote:
> Hi,
> 
> Is there a standard procedure to execute two or more concurrent txns at 
> the same time? I understand that if we want to run concurrent txns, we 
> need to execute them from different psql sessions. But how do we make 
> sure that they begin execution almost at the same time.

Well different sessions be they psql or some other client. That would be 
the difficulty, determining what is submitting the transaction.

> 
> Also, I'm interested in measuring the time taken across all executing 
> txns, i.e. the time from the start of the earliest txns till the end of 
> the last txn.

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

> 
> Best,
> -SB


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: gtreguier@free.fr
Дата:
Сообщение: Sequential scan with composite type in primary key
Следующее
От: PegoraroF10
Дата:
Сообщение: Re: Too slow to create new schema and their tables, functions,triggers.