Re: [google-cloud-sql-discuss] Re: Increasing max_wal_size

Hi Mike,

You are right - we don't provide a way to edit postgresql.conf directly, and max_wal_size is not one of parameters we expose through flags. It is also unlikely that we will start exposing it in near future.

However, we set it to 1.5G on most of the instances. We did some preliminary testing and found out that  on our infrastructure higher values provide diminishing returns while increasing crash recovery times. So we felt 1.5G is a good trade-off between performance and MTTR in case of a failure.

We may of course revisit this decision in the future. Please open a feature request if you feel like this is limiting performance for your workload.

Thank you for using our service!

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Sun, Oct 29, 2017 at 10:00 PM, Mike Hardy <mhardy@localinsights.io> wrote:

Kenworth,thanks but I don't think Cloud SQL users can edit postgresql.conf, can we? If it is possible, please share the documentation.

--
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/a6dbccfd-6111-4437-9075-e1dcb151f66d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/CAE1wr-xr9-H_Uk2O0XV6G7Jbsg_21sQ-_gQ86opPen2Jxc9kFQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.