Bug report #21241

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

Added by Cristian Guillen about 5 years ago. Updated about 5 years ago.

Status:Open
Priority:High
Assignee:-
Category:Attribute table
Affected QGIS version:3.4.4 Regression?:Yes
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29059

Description

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 issues

Duplicated by QGIS Application - Bug report #21305: pasting features to postgis (or other slow/remote backend... Closed 2019-02-18

History

#1 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Open to Feedback

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

#2 Updated by Cristian Guillen about 5 years ago

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

Yes, Postgis table has similar structure as gpkg table.

#3 Updated by Giovanni Manghi about 5 years ago

  • Priority changed from Normal to High
  • Subject changed from Copy/Paste between tables (Geopackage to Postgis) to Copy/Paste between tables is much more slower compare to 2.18
  • Status changed from Feedback to Open
  • Regression? changed from No to Yes

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.

#4 Updated by Alessandro Pasotti about 5 years ago

  • Duplicated by Bug report #21305: pasting features to postgis (or other slow/remote backends) is very slow added

Also available in: Atom PDF