title: Insert 2 Million rows into timscaldb with python-dataframes
body: <p>i want to insdert About 2 Million rows from a csv into postgersql.
  There are 2 ways. </p>
  
  <ul>
  <li>With dataframes in python </li>
  <li>or directly with Import csv in PostgreSQL</li>
  </ul>
  
  <p>The python way:</p>
  
  <pre><code>engine = create_engine("postgresql+psycopg2://postgres:passwd@127.0.0.1/postgres")
  con = engine.connect()
  df = pd.read_csv(r"C:\2million.csv",delimiter=',',names=['x','y'],skiprows=1)
  df.to_sql(name='tablename',con=con,schema='timeseries',if_exists='append',index=False)
  print("stored")
  </code></pre>
  
  <p>Took 800 seconds to insert.
  the way with directly Import in PostgreSQL took just 10 seconds. </p>
  
  <p>I thought, that the inserttime with timescaledb is much faster than 800 seconds, for inserting 2Million rows. </p>
  
  <p>Or is the way i am trying to insert the rows simply the limiting factor ? </p>