問題文
The number of concurrent workers must grow tenfold, but the database server's connection limit cannot be raised proportionally. Which approach addresses the constraint, and what does it cost?
選択肢
- Switch the workers to a vector index so that each query completes faster and therefore holds its connection for a shorter time, keeping the peak count within the limit
- Place a pooler in front so that many client connections share fewer server connections, accepting the pooler as an additional component to operate and a possible restriction on session-scoped features
- Reduce the number of concurrent workers and queue the remaining work, accepting longer end-to-end latency as the only way to respect a limit that cannot be raised
- Increase the server's memory and compute tier, which raises the connection limit proportionally and therefore accommodates the tenfold growth directly