I have a table which holds 750M per day for 90 days at once.
this is my Hierarchical partitioning logic
`PARTITION BY (mytable.TIMESTAMP_DAY)
GROUP BY
(CASE WHEN ("datediff"('year', mytable.TIMESTAMP_DAY, ((now())::timestamptz(6))::date) >= 1)
THEN (date_trunc('year', mytable.TIMESTAMP_DAY))::date
WHEN ("datediff"('month', mytable.TIMESTAMP_DAY, ((now())::timestamptz(6))::date) >= 2)
THEN (date_trunc('month', mytable.TIMESTAMP_DAY))::date ELSE mytable.TIMESTAMP_DAY END);`
when I try to call DROP_Partitions function for dates beyond 90 days like for ex if I try to drop 2024-09-13 it takes forever , infact its running for 4hrs now and not finished yet. But if I try to drop something in this month its very quick, How do i tackle this?
