postgres: use wait_for in disconnect
This is recommended by asyncpg [1].
1: https://github.com/MagicStack/asyncpg/blob/92c2d81256a1efd8cab12c0118d74ccd1c18131b/asyncpg/pool.py#L655-L656
Note that there is also a timeout for acquire, which gets used by release then also: https://github.com/MagicStack/asyncpg/blob/92c2d81256a1efd8cab12c0118d74ccd1c18131b/asyncpg/pool.py#L560-L564
This is a good call yup.
Presumably we also want to add the timeout to acquire right?
Any thoughts about adding timeout to the API someplace, and using that value?
@vmarkovtsev
I can take care of finishing this PR if you don't have time right now. WDYT?
Sure, please go ahead. (Sorry for the late reply, of course)
Any progress on this?