title: Regarding storing Lat / Lng coordinates in Postgresql (Column type)
body: <p>I am relatively new to postgresql which is why I turn to those more experienced with it than I.</p>
  
  <p>I am storing coordinates in a postgresql database.</p>
  
  <p>They look like this: <code>35.21076593772987,11.22855348629825 35.210780222605616,11.22826420209139 35.210777635062875,11.228241328291957 35.210766843596794,11.228219799676775 35.210765045075604,11.228213072050166 35.21076234732945,11.228200962345223 35.21076324691649,11.228186161764323 35.21077314123606,11.228083902231146 35.210863083636866,11.227228492401766</code></p>
  
  <p>They can range in length from around <strong>800</strong> characters up to <strong>7000</strong>.</p>
  
  <p>They always include: </p>
  
  <ul>
  <li>Numbers (<code>0-9</code>)</li>
  <li>Spaces ( <code></code>)</li>
  <li>Punctuation marks and commas (<code>. ,</code>)</li>
  </ul>
  
  <p>But they can also include: </p>
  
  <ul>
  <li>Vertical bars ( <code>|</code> )</li>
  </ul>
  
  <p>Right now I am storing them as <em>TEXT</em>, but to my understanding <em>TEXT</em> is stored externally which has an effect on performance. Would you recommend switching to another column type? If so, which one?</p>
  
  <p>Thank you very much.</p>