[postgis-users] Extract start/end points

[Aurélien FILEZ]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120317/4e044456/attachment.html>