Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Processing: Import into PostGIS slow #19237

Closed
qgib opened this issue Jul 10, 2014 · 6 comments
Closed

Processing: Import into PostGIS slow #19237

qgib opened this issue Jul 10, 2014 · 6 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms

Comments

@qgib
Copy link
Contributor

qgib commented Jul 10, 2014

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 10869
Affected QGIS version: 2.4.0
Redmine category:processing/qgis
Assignee: Victor Olaya


The tool is far slower than the old SPIT plugin, to the point that it cannot be an effective replacement for large data set. Perhaps the -D [Use postgresql dump format (defaults to SQL insert statements)] should be used?

@qgib
Copy link
Contributor Author

qgib commented Jul 11, 2014

Author Name: Victor Olaya (@volaya)


I am not an expert on that. But if you reccomend that change, it looks like an easy thing. I will look at SPIT to see how it does it.

@qgib
Copy link
Contributor Author

qgib commented Jul 11, 2014

Author Name: Paolo Cavallini (@pcav)


Please have a look to dbmanager too.

@qgib
Copy link
Contributor Author

qgib commented Jul 14, 2014

Author Name: Paolo Cavallini (@pcav)


Correction: DB Manager is apparently equally slow

@qgib
Copy link
Contributor Author

qgib commented Nov 22, 2014

Author Name: Alexander Bruy (@alexbruy)


  • category_id was changed from 94 to Processing/QGIS

@qgib
Copy link
Contributor Author

qgib commented Feb 3, 2015

Author Name: Giovanni Manghi (@gioman)


Given the fast ogr based tools we will have in qgis 2.8 it could be useless to fix this.


  • status_id was changed from Open to Feedback

@qgib
Copy link
Contributor Author

qgib commented Feb 3, 2015

Author Name: Giovanni Manghi (@gioman)


I spoke with Paolo and he suggested to close this.


  • resolution was changed from to wontfix
  • status_id was changed from Feedback to Closed

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms labels May 25, 2019
@qgib qgib closed this as completed May 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms
Projects
None yet
Development

No branches or pull requests

1 participant