[google-cloud-sql-discuss] Re: Is it possible to change workmem for postgres?

Hello George,

My apologies if I misspoke about ALTER SYSTEM command. It does require superuser access. I performed the test in my lab system and it is possible to set work_mem  "per-session" without superuser privileges, Below is the output :

postgres=> set work_mem = '5MB';

SET

postgres=> show work_mem;

work_mem

----------

5MB

(1 row)

As you mentioned, since Cloud SQL is a managed instance it is not possible to perform this setup at the system level. Please note changing the "work_mem" might drive the system into an undesirable state.

--
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/2b1e3302-c3f6-4ed5-98e3-f4c4dc5fe580%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.