[Qgis-developer] Reverse order in PostGIS commit?

Tim Keitt tkeitt at utexas.edu
Thu Jul 10 14:12:14 PDT 2014


On Wed, Jul 9, 2014 at 1:40 AM, Jürgen E. <jef at norbit.de> wrote:

> Hi Paolo,
>
> On Tue, 08. Jul 2014 at 15:48:22 +0200, Paolo Cavallini wrote:
> > I have just noticed that when digitizing new shapes, they get written
> > in a PostGIS table in a reverse order respect to the digitizing order;
>
> You refer to the order of INSERTs?  Why does that matter?   The order in
> which
> you get back the feature after INSERT later is undefined anyway.
>

This is correct. You can get pretty good speedups by clustering your table
on the r-tree index. That reorders the entire table placing spatially
nearby objects nearby in the storage layer.

No one has specified a concrete example, so its pretty difficult to have
any idea what you need. Time stamp + a sorted view? (And top posting makes
this thread pretty hard to understand as well.)

THK


>
>
> Jürgen
>
> --
> Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
> Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
> Software Engineer           D-26506 Norden
> http://www.norbit.de
> QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode
>
> --
> norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
> Rheinstrasse 13, 26506 Norden
> GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
http://www.keittlab.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140710/b5f39c4c/attachment.html>


More information about the Qgis-developer mailing list