3 ms·
I went with Aurora Postgres recently for a new application and to be honest it fucking sucks. When it scales up, queries start to fail and there are long delay
by CoolGuySteve 7y ago
I went with Aurora Postgres recently for a new application and to be honest it fucking sucks.
When it scales up, queries start to fail and there are long delays. I had to add a try/retry loop around all my inserts to avoid losing data.
I definitely wouldn't recommend it for bursty applications where it needs to rapidly scale up.
The thing that bugs me is that I know a similar workload works fine on a relatively cheap c3.xlarge so I'm not actually saving much money with Aurora.
- nostrebored 7y ago... were you not handling errors on database inserts through well established concepts like exponential backoff and retry already? that seems like a colossally bad idea If you don't need the striped storage model and guarantees that Aurora provides, it might not be the service for you
- CoolGuySteve 7y agoNormally I’d agree with you but I was only doing a dozen or so inserts per second for maybe a minute or two after hours of idleness. There was no back off because it was never needed before, even the shittiest instance could handle it without issue but Aurora failed spectacularly.