[Qgis-developer] Deleting records from PostGIS

[Necip Enes GENGEÇ]

Hi Paolo,

I tested with a table of 9000~ features. It took me almost no time to
delete half of the table. (Config: Ubuntu 14.04, QGIS 2.4, Postgresql 9.3)

I experienced something like this while I was working with a active
delete/update trigger of the subjected table in oracle before.

Regards,
Necip

On 11 September 2014 15:57, Paolo Cavallini <cavallini at faunalia.it> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all.
> I'm noticing that deleting a large number of records from a PG table
> tekes an enormous amount of time. I imagine this is due to individual
> delete, une per record. Is there a way to speed this up?
> All the best.
> - --
> Paolo Cavallini - www.faunalia.eu
> QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iEYEARECAAYFAlQRnCMACgkQ/NedwLUzIr5LugCgjuSwNoR+eZsircuJGQdsBlYe
> o7wAn0DvO0x31znGmrmsR0hFHikQ11fS
> =ldvZ
> -----END PGP SIGNATURE-----
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140911/60c0f958/attachment.html>