On Sat, 2024-03-23 at 22:41 +0530, veem v wrote:
> 1)As we see having foreign key defined is making the detach partition run
> for minutes(in our case 5-10minutes for 60 million rows partition), so
> how to make the parent table partition detach and drop work fast in such
> a scenario while maintaining the foreign key intact?
I told you: don't do it.
Instead, use foreign keys between the partitions.
Yours,
Laurenz Albe