Hello,
-- Postgres is crashing (most probably getting killed by Linux OOM).
Also, "vacuum full;" is not releasing space (CloudSQL console says almost 70GB are in use).
At the same time pg_total_relation_size() says my largest table has less than 200MB (others have < 1MB).
But how can I investigate and fix this with the tools CloudSQL provides?
The table sizes I have make it even stranger that an instance with 3.75GB memory cannot keep up with the update scenario I have.
The table sizes I have make it even stranger that an instance with 3.75GB memory cannot keep up with the update scenario I have.
Also, "vacuum full;" is not releasing space (CloudSQL console says almost 70GB are in use).
At the same time pg_total_relation_size() says my largest table has less than 200MB (others have < 1MB).
Any suggestion how to fix this?
Regards,
Carlos
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/4daf17f0-a599-40d0-a55e-ec294ccee08d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment