Postgres: DISCARD ALL about bb8 HOT 5 OPEN

Might be nice to have a look at other pooling solutions (r2d2, deadpool, sqlx) and see if/how they support this.

(Note that previously we recommended that LISTEN queries should probably be issued on non-pooled connections, through Pool::dedicated_connection().)

from bb8.

PgBouncer has it configurable (server_reset_query) but it defaults to DISCARD ALL. PgBouncer is probably the gold standard when it comes to Postgres pooling.

It’s really not about the LISTEN, but all (currently 9) resources this releases. Another nice thing is that it fails if the connection is inside a transaction, so it helps automatically check that you’re closing them correctly.

I think it needs to be configurable, otherwise you loose the ability to share use prepared statements etc. Choose your own isolation level...

from bb8.

I was referring mostly to Rust crates.

I'm unlikely to have time for this any time soon unless someone is willing to pay for it. Will review hooks for this in the connection manager trait, though.

from bb8.

Yes, I think hooks are key rather than supporting every single possible reset query. Then one can subclass the postgres manager and do what they want.

from bb8.

#89 added a way to customize connections at the start of the lifetime rather than the end, which should help with this.

from bb8.