The issue is most likely happening due to the database behavior. More specifically due to complicated queries that create a lot of temporary tables at a certain point in time. PostgreSQL here will behave the same way as MySQL so it may rapidly accumulate a lot of temp tables on disk, but then will remove them as soon as the queries finish. In order to check the instance storage usage, check on Cloud Console > SQL > "instance" > Overview tab. Also, check the replica current storage size.
Note that it is not possible to decrease the size of the instance once it has increased. However, it is possible to edit the instance settings [2] and disable the automatic storage increase, but that the database may stop accepting incoming connections and go offline if it runs out of space [3].
I hope it helps you identify the reason why the instance storage increased.
I have a DB postgres and 1 replica DBUntil Yesterday, my DB only about 300MB(replica DB is the same).But from yesterday, DB storage usage increase to ~4.5GB.(but i see replica DB still just 300MB)I checked log and see that, many temp file has been created.--path "base/pgsql_tmp/pgsql_tmp20714.0", size 4882432 --It this the reason make storage increase?Why it does not happen in past.Anyone give me advice?Thank you!
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/52aecb82-70fa-43e3-8fbe-346bbe08f5f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment