Copy/Paste between tables is much more slower compare to 2.18

[qgib]

Author Name: Cristian Guillen (Cristian Guillen)
Original Redmine Issue: 21241
Affected QGIS version: 3.4.4
Redmine category:attribute_table

---

Copy and paste a lot of records from a Geopackage table to a PostGIS table and save changes take much longer in QGIS 3.4.4 than in QGIS 2.18.

---

Related issue(s): #29123 (duplicates)
Redmine related issue(s): 21305

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Can define "a lot"? Can you also attach a sample gpkg (I assume the postgis table is equal to the gpkg one)?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Cristian Guillen (Cristian Guillen)

---

I attach a sample: https://drive.google.com/file/d/1SXuUqyVVIpj3CHQUqh1opo84QzWhJdjK/view?usp=sharing

Yes, Postgis table has similar structure as gpkg table.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Confirmed, just a few seconds max on 2.18... minutes (or even possible complete freeze, I stopped the program after 5 min) on 3.4.4... copy/pasting ~18000 records/features, that do not seem much anyway.

---

• priority_id was changed from Normal to High
• subject was changed from Copy/Paste between tables (Geopackage to Postgis) to Copy/Paste between tables is much more slower compare to 2.18
• status_id was changed from Feedback to Open
• regression was changed from 0 to 1

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• duplicated was configured as pasting features to postgis (or other slow/remote backends) is very slow #29123

[gioman]

Closing as this seems to have been fixed.