[Qgis-developer] Reverse order in PostGIS commit?
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
> 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.)
> 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Qgis-developer