Re: Running concurrent txns and measuring the timings in Postgres

[Rob Sargent <robjsargent@xxxxxxxxx>]

On Jul 24, 2019, at 1:22 PM, Souvik Bhattacherjee <kivuosb@xxxxxxxxx> 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.

--
adrian.klaver@xxxxxxxxxxx

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.