<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr"><span id="yui_3_16_0_1_1435182159998_3939">and now...it failed:</span></div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr"><span><br></span></div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style="">WARNING: terminating connection because of crash of another server process</div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style="">DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style="">HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style="">********** Error **********</div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style=""><br class="" style=""></div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style=""><br class="" style=""></div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr"></div><div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style="">Connection reset.</div> <div id="yui_3_16_0_1_1435182159998_3938" dir="ltr" class="" style=""><span class="" style=""><br class="" style=""></span></div><br><div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font size="2" face="Arial"> On Wednesday, June 24, 2015 11:05 AM, Ruth Simm <goldfish_and_muskie@yahoo.com> wrote:<br> </font> </div> <br><br> <div class="y_msg_container"><div id="yiv2674821466"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div id="yiv2674821466yui_3_16_0_1_1435168804183_3728">Hi all,</div><div id="yiv2674821466yui_3_16_0_1_1435168804183_3931"><br></div><div dir="ltr" id="yiv2674821466yui_3_16_0_1_1435168804183_3760">I began running this query on a table with 19,763 rows...and it is taking forever (up to 14 hours and still running). I was wondering if there was any other way to optimize this... (note: without creating edges with Topology - which is equally slow)? </div><div id="yiv2674821466yui_3_16_0_1_1435168804183_3985" dir="ltr"><br></div><div id="yiv2674821466yui_3_16_0_1_1435168804183_4032" dir="ltr">Thank you for your time.<br></div><div id="yiv2674821466yui_3_16_0_1_1435168804183_4031" dir="ltr"><br></div><div id="yiv2674821466yui_3_16_0_1_1435168804183_3973" dir="ltr">Specs:</div><div id="yiv2674821466yui_3_16_0_1_1435168804183_3974" dir="ltr">PostgreSQL 9.2.4</div><div id="yiv2674821466yui_3_16_0_1_1435168804183_3990" dir="ltr">PostGis 2.1.0</div><div id="yiv2674821466yui_3_16_0_1_1435168804183_4008" dir="ltr"><br></div><div id="yiv2674821466yui_3_16_0_1_1435168804183_4007" dir="ltr">SELECT row_number() OVER() new_id, geom <br style="" class="yiv2674821466">INTO linestrings FROM<br style="" class="yiv2674821466"> (SELECT <br style="" class="yiv2674821466"> (ST_Dump(ST_Node(ST_Union(geom)))).geom geom <br style="" class="yiv2674821466"> FROM multlinestrings) a;<br></div><div style="" class="yiv2674821466" id="yiv2674821466yui_3_16_0_1_1435168804183_4007" dir="ltr"><br style="" class="yiv2674821466"></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>