We are inserting data close to 1M record & having a single Jsonb column but query is getting stuck.
We are using insert into select * .. , so all the operations are within the DB.
If we are running select query individually then it is returning the data in 40 sec for all rows but with insert it is getting stuck.
PG Version - 15.
What could be the problem here ?
Regards,
KD
