title: Efficient way to import a lot of csv files into PostgreSQL db
body: <p>I see plenty of examples of importing a CSV into a PostgreSQL db, but what I need is an efficient way to import 500,000 CSV's into a single PostgreSQL db. Each CSV is a bit over 500KB (so grand total of approx 272GB of data).</p>
  
  <p>The CSV's are identically formatted and there are no duplicate records (the data was generated programatically from a raw data source).  I have been searching and will continue to search online for options, but I would appreciate any direction on getting this done in the most efficient manner possible. I do have some experience with Python, but will dig into any other solution that seems appropriate.</p>
  
  <p>Thanks!</p>