I have a query like this:
insert into table1 (field1, field2) select (field1, field2) from table2
It's running on a huge table with millions of rows. It might take several hours or days but it wouldn't be a problem. The problem is right now that my client (dbeaver) constantly dropping the connection and my query fails. How would you handle this problem?