Running concurrent txns and measuring the timings in Postgres

From: Souvik Bhattacherjee <kivuosb(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Running concurrent txns and measuring the timings in Postgres
Date: 2019-07-24 16:54:00
Message-ID: CAANrPSeXewRj2NehjMog-=zuYUbfz677iUOV1j-Gzm94XcJ9Lg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gtreguier 2019-07-24 17:04:53 Sequential scan with composite type in primary key
Previous Message Alexey Bashtanov 2019-07-24 16:38:01 Re: after restore the size of the database is increased