The main ideaThe source code of QGIS reveals, that the limitation is set inside the C++ file qgsvectorlayerexporter.cpp: Now, there are two ways to take a better and faster way: write your own processing or use a default one. The latter will be part of this blog post: the GDAL processing tools.
ogr2ogr FTWThe GDAL processing toolbox provides a set of tools for both vector and raster processing. Victor Olaya already served us with a dedicated import tool for bigger datasets:
This uses the ogr2ogr command from the QGIS installation and pushes the data into your defined PostGIS db.
ComparisonI’ve checked the differences with a dump from OSM which has 23.000 points. The results are stunning but of course somehow predictable as we compare 200 with 20.000 features per transaction:
The import with the prcoessing tool took about 18seconds. This is great, compared to the 20mins using the normal drag and drop within QGIS: