title: Index creation taking forever on postgres
body: <p>I was trying to create an index to an integer column using a btree index, but it was taking forever (more than 2 hours!).
  The table has 17.514.879 lines. I didn't expect it to take that long.</p>
  
  <p>After almost 2.5 hours, the connection to the database just died. When I reconnected to it, the index was there, but I don't know how good is this index.</p>
  
  <p>How can I be sure the index was not messed up by the connection lost?</p>