On Thu, May 25, 2017 at 11:34 AM, Tsunakawa, Takayuki <tsunakawa.ta...@jp.fujitsu.com> wrote: > From: pgsql-hackers-ow...@postgresql.org >> [mailto:pgsql-hackers-ow...@postgresql.org] 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 (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers