How to break your DBMS with arised-from-nothing high loads?
Team member of backend-developers at Modulbank. Professional interests include development on .net platform and performance troubleshooting. Perceive optimization of slow queries in Postgres as a personal challenge.
As any ordinary software developers, we just pursued a goal to develop a system robust for high loads, and even succeeded. The system architecture was fine, but the data volume was keeping increased and revealed the painful issues and errors that nobody had expected. We faced very strange queries seemed to be unbelievable. In my short talk I would like to share sad experience of arised-from-nothing high loads in DBMS and solving the challenge.