One of the things I love about #Postgres in @AWS #RDS is the ability to resize an instance with minimal downtime. I had a CPU saturated instance running a m4.4xl. I switched to a m5.4xl to see the impact. < 15s downtime and shaved 20ms off query times (60ms avg to 40ms avg)
-
-
Yeah, that I do. It’s doing hourly and daily rollups across 3 dimensions in real-time. The number of procs waiting on lock are crazy at the moment. I’m playing with consumer quantities to try and find the best throughput level.
-
It currently is hitting 10k queries per second of the same query. Yeah locks are high, but I can’t complain TBH.
- 1 more reply
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.