[google-cloud-sql-discuss] Re: Excessive Memory Usage - Postgres

Hi George, memory usage stayed high until I restarted the instance. That's not practical when we're in production.

The Cloud SQL FAQ resource seems related to billing, which I have no doubts about. We plan to use this instance continuously with no/minimal downtime.

On Monday, October 30, 2017 at 12:33:08 PM UTC-7, George (Cloud Platform Support) wrote:

Hello Mike, 

Is memory usage still high in value right now? If your instance hasn't been in use for a while, and the activation policy value is set to "ON_DEMAND", there will be little memory usage shown prior to actual use, in your case the backup restore operation. Your instance remains up for 15 minutes after the completion of the last access, so you won't notice an immediate drop in memory usage. This is documented in the "How is use of my instance calculated?" sub-chapter of the "Cloud SQL FAQ" online document. 

For the actual tuning of your PostgreSQL database, you may have a look at the "18.4. Resource Consumption" page of the PostgreSQL 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/3988ec70-98f2-46c0-80a3-acf0118391c5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.