Hi,
-- I hope I don't post this duplicate because I already posted this, but I cannot find it anywhere so maybe something went wrong.
We are migrating our APP + DB to Google Cloud. However, we can't get the database to a level of performance as needed. We created a heavy select query with lots of joins and on my local PC it's way faster than it's on Google Cloud SQL. We are moving from a managed Amazon solution, and the current setup on Amazon is also faster. On both my PC and Amazon it's somewhere nere 30% faster on any query.
How come Google Cloud SQL Postgres is so slow? I tried a lot of things to increase the performance:
- Upgraded the disk to improve read/write speed as suggested by Google
- Added more CPUs and RAM (makes no difference)
- The database instance runs in Frankfurt which is close to my home so I don't think there is any noticable latency on this end
What else can I try to improve the performance? I find it very strange that my PC (which is not optimized to run Postgres) is 30% faster than a optimized instance on Google Cloud.
How can I debug this and how can I improve this?
Thanks!
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/9c4f1d1e-a009-4255-a5a8-4d0d660dde81%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment