⚡️ POSTGRESQL Database Tip

Kiran Kumar
Apr 19, 2023

--

Deleting hundreds of thousands of rows is slow, impacts your performance and doesn’t free the allocated disk space. But you can delete old data very efficiently if you partition your table by time ranges and drop one of them.

--

--

Kiran Kumar
Kiran Kumar

Written by Kiran Kumar

Technophile with 12.5 years experience in IT industry | Java Technical Manager cum Architect

No responses yet