Running concurrent txns and measuring the timings in Postgres - Mailing list pgsql-general

From Souvik Bhattacherjee
Subject Running concurrent txns and measuring the timings in Postgres
Date
Msg-id CAANrPSeXewRj2NehjMog-=zuYUbfz677iUOV1j-Gzm94XcJ9Lg@mail.gmail.com
Whole thread Raw
Responses Re: Running concurrent txns and measuring the timings in Postgres
List pgsql-general
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.

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.

Best,
-SB

pgsql-general by date:

Previous
From: Alexey Bashtanov
Date:
Subject: Re: after restore the size of the database is increased
Next
From: gtreguier@free.fr
Date:
Subject: Sequential scan with composite type in primary key