v0.1.57

Performance

• SCRAM client authentication (which uses expensive crypto) is now pushed to background threads, which will avoid blocking other clients from running queries during connection storms

Features

• Add listen_backlog configuration setting to control how many new, concurrent, TCP connections PgDog will allow until they are silently rejected @ryderhwang
• DISCARD now clears client's prepared statement cache, advisory locks & notification channels @murex971
• CREATE TEMP TABLE now pins the client connection until the table is dropped or the client disconnects @sgrif
• Count and show number of idle-in-transaction timeouts as a pool statistic @murex971
• Add support for SCRAM-SHA-256-PLUS client authentication @abnegate
• Add banned gauge to OpenMetrics and OTEL indicating which database is currently blocked from reads by the load balancer @ChrisJr404

Bugs

• Fix cross-shard variance() crash when empty/null results returned by shards @sgrif
• Prepared statements prepared via simple protocol now respect prepared_statements_ttl @jkaczman

Code quality

• Refactor resharding task queue to use more types @meskill
• Clean up resharding logging @levkk
• Refactor the query engine code to support cross-shard subqueries and CTEs @jkaczman

New Contributors

• @ryderhwang made their first contribution in #1452
• @abnegate made their first contribution in #1457
• @mvidaurre made their first contribution in #1483
• @ChrisJr404 made their first contribution in #1443

Full Changelog: v0.1.56...v0.1.57