Виталий Сушков — Оптимизация через партицирование

Learn more about the DotNext conference: https://jrg.su/3WmFRE — — Download the presentation from the DotNext website — https://jrg.su/BfvMNA A story about optimizing a service that had become unable to cope with its responsibilities due to the growing volume of processed data. The speaker described the techniques used to immediately restore the service to normal operation and prepare for future multiple increases in load with minimal resource consumption. He paid special attention to the use of declarative table partitioning in PostgreSQL: how it was implemented on a large, busy database without service downtime, the challenges encountered, and how they were overcome.