Hi Moin, PostgreSQL Function would be wise call for your requirement. Function can have below path to drop the child partition table with respective to the provided Master table and retention policy. And then you can call the function by setting it in the crontab. 1. Function should select the child tables with respective to the provided Master table. 2. Soon after receiving child table list. Un-bound the child table depends on the retention policy. (ex. 7 days) 3. And then drop the table after validating the data if it is old enough. Note: Also, we would suggest to test this test case in your Test enviornment, before, trying it on the Prod. Hope this helps.
... View more