On Jan 28, 2013, at 4:10 PM, Vincent Picavet wrote: > Hi William, > >> On Jan 28, 2013, at 3:05 PM, William Kyngesburye wrote: >>> I'm trying to split a selected line feature in a postgis database on the >>> network (not local machine). The database layer is almost 4GiB (10M >>> records) and is spatially indexed. > > Do you have a primary key defined on your PostGIS table ? > yes
> Vincent > >>> >>> The feature is selected, it's not very large and I am zoomed to see about >>> half of it. It took about a half hour to split, and during that time >>> was downloading a constant stream from the postgis server. I'm guessing >>> it looked at every feature in the database. >>> >>> bug? (didn't see anything in the tracker) lack of optimization? maybe >>> it was fixed in trunk? Continuing to edit this database will be >>> impractical as it is in 1.8. >>> >>> >>> QGIS 1.8, OS X >>> >>> ----- >>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> >>> http://www.kyngchaos.com/ >>> >>> Theory of the Universe >>> >>> There is a theory which states that if ever anyone discovers exactly what >>> the universe is for and why it is here, it will instantly disappear and >>> be replaced by something even more bizarrely inexplicable. There is >>> another theory which states that this has already happened. >>> >>> -Hitchhiker's Guide to the Galaxy 2nd season intro >>> >>> >>> _______________________________________________ >>> Qgis-developer mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >> ----- >> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> >> http://www.kyngchaos.com/ >> >> First Pogril: Why is life like sticking your head in a bucket filled with >> hyena offal? Second Pogril: I don't know. Why IS life like sticking your >> head in a bucket filled with hyena offal? First Pogril: I don't know >> either. Wretched, isn't it? >> >> -HitchHiker's Guide to the Galaxy >> >> >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > _______________________________________________ > Qgis-developer mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer ----- William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> http://www.kyngchaos.com/ "I ache, therefore I am. Or in my case - I am, therefore I ache." - Marvin _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
