Tuesday, September 25, 2018

[google-cloud-sql-discuss] My postgres DB increase storage usage non-stop

I have a DB postgres and 1 replica DB
Until 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/92fc19b1-4789-4dab-87ec-396fcfcff046%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment