title: Handle >10 million rows for one table (postgresql)
body: <p>I imported 11 Million location names from geonames.org into my postgresql. However when I try to just view the data for instance in TablePlus it is extremely slow. Executing a simple select for one row, takes like 2 minutes. What can I do with large data, so that it won't be too slow and I can select it very fast?</p>
  
  <p>I think I don't have any indexes, would that make a difference?</p>
  
  <p>This is my table:</p>
  
  <pre><code>create table geoname (
      geonameid   int,
      name varchar(200),
      asciiname varchar(200),
      alternatenames text,
      latitude float,
      longitude float,
      fclass char(1),
      fcode varchar(10),
      country varchar(2),
      cc2 varchar(120),
      admin1 varchar(20),
      admin2 varchar(80),
      admin3 varchar(20),
      admin4 varchar(20),
      population bigint,
      elevation int,
      gtopo30 int,
      timezone varchar(40),
      moddate date
   );
  </code></pre>