Re: Retry in pgbench

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: jgdr(at)dalibo(dot)com
Cc: thomas(dot)munro(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Retry in pgbench
Date: 2021-04-16 01:28:48
Message-ID: 20210416.102848.1267569332707619808.t-ishii@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

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