Reason why I feel 10 minutes is way too long is because, I have written 90 lakhs data table in few minutes, but after this spatial data, even when row count is way less than 90 lakh, say 35 lakh, it is still taking 10 minutes, which shouldn't be the case, considering the final dataset I am writing does not even have geometry column, it has some regular string and numeric columns, 10-12 in number.

Additionally, this duration is not acceptable because I have 3000 such datasets to process, as I already partitioned by data because of volume, still no performance improvement.

Rest will try the other things you have mentioned.

Thanks for your input.