The post discusses the process of building a weather data warehouse using PostgreSQL and TimescaleDB. It explores the need for historical weather data, the ERA5 climate reanalysis product, and the challenges of loading large amounts of data into a database. The post compares different insertion methods, including single-row
•15m read time• From aliramadhan.me
Table of contents
What are we even doing?The insert statementThe copy statementToolsTweaking Postgres settingsSo what’s the best method?AppendicesFootnotesSort: