Re: Retry in pgbench - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Retry in pgbench
Date
Msg-id 20210416.102848.1267569332707619808.t-ishii@gmail.com
Whole thread Raw
In response to Re: Retry in pgbench  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Responses Re: Retry in pgbench  (Fabien COELHO <coelho@cri.ensmp.fr>)
Re: Retry in pgbench  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
List pgsql-hackers
> By the way, I've been playing with the idea of failing gracefully and retry
> indefinitely (or until given -T) on SQL error AND connection issue.
> 
> It would be useful to test replicating clusters with a (switch|fail)over
> procedure.

Interesting idea but in general a failover takes sometime (like a few
minutes), and it will strongly affect TPS. I think in the end it just
compares the failover time.

Or are you suggesting to ignore the time spent in failover?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: "could not find pathkey item to sort" for TPC-DS queries 94-96
Next
From: Noah Misch
Date:
Subject: Re: Converting contrib SQL functions to new style