GoogleCloudPlatform / pgadapter

PostgreSQL wire-protocol proxy for Cloud Spanner
https://cloud.google.com/spanner/docs/postgresql-interface#postgresql-client-support
Apache License 2.0
54 stars 20 forks source link

feat: support max_commit_delay for COPY #2147

Closed olavloite closed 1 month ago

olavloite commented 1 month ago

The SQL statement set spanner.max_commit_delay='20ms' or similar can be used to set a maximum commit delay that is allowed for a transaction, which again can improve throughput for writes. This setting was not used by PGAdapter for COPY statements. This changes ensures that the max_commit_delay that has been set for a connection will also be used for any COPY statement on that connection.