4 ms·
What volume of data are you storing in postgres? Any reason not to use a hosted postgres provider? At first glance it seems like a lot of compute for the servic
by albertgoeswoof 4y ago
What volume of data are you storing in postgres? Any reason not to use a hosted postgres provider? At first glance it seems like a lot of compute for the service but curious about scale
- cuu508 4y agoAround 200 write tx/s as a baseline. Spikes to 2000 write tx/s at the start of every minute, and 4000 write tx/s every 10 minutes. > Any reason not to use a hosted postgres provider? * Cost * Schrems II * From what I remember, both Google Cloud SQL and AWS RDS used to have mandatory maintenance windows. The fail-over was not instant, so there was some unavoidable downtime every month. This was a while ago – maybe it is different now.
- avrionov 4y agoI don't think that this will work differently than you manually updating your databases. GCP claims that maintenance downtime is less than 60 seconds.