[google-cloud-sql-discuss] Make the work_mem configurable

My Google Cloud SQL log is flooded with messages complaining about log_temp_files, e.g.

17:33:54.069 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp26120.0", size 2971444

This is primarily because I cannot control the value of work_mem.

curiosity~ % gcloud sql instances patch mother --database-flags work_mem=8MB
When adding a new IP address to authorized networks, include existing
authorized IP addresses. Any existing authorized IP address not
included will be de-authorized.


Do you want to continue (Y/n)?  Y


The following message will be used for the patch API method.
{"project": "applaudience", "name": "mother", "settings": {"databaseFlags": [{"name": "work_mem", "value": "8MB"}]}}
WARNING: This patch modifies a value that requires your instance to be
 restarted. Submitting this patch will immediately restart your
instance if it's running.


Do you want to continue (Y/n)?  Y


ERROR: (gcloud.sql.instances.patch) HTTPError 404: Flag requested cannot be set.

Please make work_mem configurable, as it is one of the essential configurations.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e14c0162-e01f-4f9e-b5e8-b07cfa7901db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.