Pgb-02 PgBouncer query_wait_timeout Issue

Description:
The `query_wait_timeout` parameter in PgBouncer controls how long a client query is allowed to wait in the queue before being dropped. When the connection pool is exhausted or under heavy load, queries may get stuck waiting for an available server connection. If they exceed the `query_wait_timeout` value, PgBouncer will terminate them with an error.

This issue usually appears in environments with:

* **High client concurrency** but insufficient `pool_size`.
* **Idle or long-running transactions** consuming server connections.
* **Misconfigured connection pooling** (e.g., low `max_client_conn` vs. application demand).

Impact:

* Applications may see errors such as:

```
ERROR: query_wait_timeout (query waited too long)
```
* User experience degradation due to failed or delayed queries.

**Resolution Approaches:**

* Tune `default_pool_size`, and `max_client_conn` based on workload.

Видео Pgb-02 PgBouncer query_wait_timeout Issue канала mynoteoracledba