<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You should be fine. Once pending ways are completed, everything else is postgresql indexing and clustering. The following commands are what I run to manually cluster and index. Note that this uses a st_geohash clustering which is faster. I use psql commands run in parallel rather than do everything in one connection.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It also does not create indexes for the slim tables, but does analyze them.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_roads ( ST_GeoHash(ST_Transform(way,4326))) WITH (fillfactor=100);<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>CLUSTER planet_osm_roads USING "planet_osm_roads_st_geohash_idx"; drop index planet_osm_roads_st_geohash_idx;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_point ( ST_GeoHash(ST_Transform(way,4326))) WITH (fillfactor=100);<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>CLUSTER planet_osm_point USING "planet_osm_point_st_geohash_idx"; drop index planet_osm_point_st_geohash_idx;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_line ( ST_GeoHash(ST_Transform(way,4326))) WITH (fillfactor=100);<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>CLUSTER planet_osm_line USING "planet_osm_line_st_geohash_idx"; drop index planet_osm_line_st_geohash_idx;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_polygon ( ST_GeoHash(ST_Transform(way,4326))) WITH (fillfactor=100);<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>CLUSTER planet_osm_polygon USING "planet_osm_polygon_st_geohash_idx"; drop index planet_osm_polygon_st_geohash_idx;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wait<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_roads USING gist (way);' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_point USING gist (way);' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_line USING gist (way);' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_polygon USING gist (way);' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wait<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_roads;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_point;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_line;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_polygon;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_ways;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'SET default_statistics_target=10000;ANALYZE planet_osm_rels;' &<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wait<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>psql -d gis -c 'CREATE INDEX ON planet_osm_polygon USING gist (way) WHERE building IS NOT NULL;'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Aiden Bell [mailto:aiden449@gmail.com] <br><b>Sent:</b> Sunday, March 23, 2014 1:20 PM<br><b>To:</b> dev@openstreetmap.org<br><b>Subject:</b> [OSM-dev] osm2pgsql commit point and index recovery<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p>Hi all,<o:p></o:p></p><p>I recently imported the osm planet file using osm2pgsql. The process crashed (hung my whole box) when creating the geometry indices and other indices on the tables. Most of the indexing completed, but the box hung on one of the last ones. Scouring through the source code, it looks fairly trivial to add the indices by hand, however I was wondering if anybody knew if the database is consistent at this point (ie, all row data comitted).<o:p></o:p></p><p>Don't want to have to start over with the whole import really.<o:p></o:p></p><p>Many thanks,<o:p></o:p></p><p>Aiden<o:p></o:p></p></div></div></div></div></body></html>