time.Sleep() after CancelRequest

[silkadenupp]

Hi, I want to use CancelRequestContextWatcherHandler to cancel requests after a context timeout on a request, and I see here time.Sleep, which in fact holds the connection for 100ms just like that. Is there, in theory, some kind of synchronization option?

pgx/pgconn/pgconn.go

Line 2509 in 98e7e9f

time.Sleep(100 * time.Millisecond)

[jackc]

PostgreSQL's cancel request mechanism simply doesn't provide a good synchronization option. We can know when the cancel signal is received by the server, but we have no way of knowing when or even if it takes effect.