title: Does Pandas release the last chunk from memory after loading the next one?
body: <p>Take the code below for example. Assuming the chunk iterator renders 10 chunks, the <strong>for loop</strong> will load all of them into memory (one after another) or Python will work efficiently releasing one after the oter?</p>
  <pre><code>df_iter = pd.read_csv(file, chunksize=100)
  
  for chunk in df_iter:
    chunk.to_sql(table, engine)
  </code></pre>
  <p>I've made some tests with files bigger than memory using the code above and got memory overflow. Do I miss something here?</p>