[postgis-users] Extract start/end points
kinju59 at gmail.com
Sat Mar 17 15:28:26 PDT 2012
I have a table of 3.200.000 linestrings and I have to extract the start
point (x1, y1) and the end point (x2, y2).
So I make :
UPDATE myTable SET x1 = St_X(St_StartPoint(the_geom));
But the query is running since 5 hours, and still not finished.
The computer is an Ubuntu Server, i3, with 4Go of RAM..
Is it normal ? Is there is something to do somewhere ?
Thank you :)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users