[Qgis-developer] split features takes a LONG time over network

[William Kyngesburye]

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
>>> Qgis-developer at lists.osgeo.org
>>> 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
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> 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