Hi all, 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 :) Kin
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
