Postgres Pro
Downloads
Home   >   mailing lists

Re: Add an optional timeout clause to isolationtester step. - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Add an optional timeout clause to isolationtester step.
Date
Msg-id 20200309221558.7kd5fuks2alvtsex@alap3.anarazel.de
Whole thread Raw
In response to Re: Add an optional timeout clause to isolationtester step.  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Add an optional timeout clause to isolationtester step.  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
Hi,

On 2020-03-07 22:17:09 +0100, Julien Rouhaud wrote:
> For reindex concurrently, a SELECT FOR UPDATE on a different connection can
> ensure that the reindex will be stuck at some point, so canceling the command
> after a long enough timeout reproduces the original faulty behavior.

That kind of thing can already be done using statement_timeout or
lock_timeout, no?

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Should we remove a fallback promotion? take 2
Next
From: David Rowley
Date:
Subject: Re: [PATCH] Erase the distinctClause if the result is unique by definition