On Thu, May 25, 2017 at 11:34 AM, Tsunakawa, Takayuki <[email protected]> wrote: > From: [email protected] >> [mailto:[email protected]] On Behalf Of Noah Misch >> Ten feels low to me. The value should be be low enough so users don't give >> up and assume a permanent hang, but there's little advantage to making it >> lower. >> I'd set it such that we give up in 1-5s on a modern Windows machine, which >> I expect implies a retry count of one hundred or more. > > Then, maybe we can measure the time in each iteration and give up after a > particular seconds.
Indeed, pgrename() does so with a 100ms sleep time between each iteration. Perhaps we could do that and limit to 50 iterations? -- Michael -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
