by Javier Morales Carreras | Mar 2, 2023 | GitHub projects
As every year, it’s time to clean up the databases Marie Kondo style. Database administrators have to historicize, compress or delete old partitions that are no longer needed. Obviously, partitioned tables (and their local indexes) are the best place to...
by Javier Morales Carreras | Dec 26, 2022 | GitHub projects
One of the “Mentor Dojo” students got this request from his manager. They wanted to estimate the growth of a all the objects of a certain tablespace or schema in one month. My first answer was “well, let’s assume the last month growth”,...