SV: copy csv into partitioned table with unique index

2018-01-28 Thread Lars Aksel Opsahl
Hei Sorry it's was a zero to much, it should 30-40 million weather observations pr second. Lars Fra: Lars Aksel Opsahl Sendt: 28. januar 2018 12:57 Til: Mariel Cherkassky; PostgreSQL mailing lists Emne: SV: copy csv into partitioned table with unique

SV: copy csv into partitioned table with unique index

2018-01-28 Thread Lars Aksel Opsahl
Hi We had the same problems with performance when testing with more than 100 billion weather observations. We now have a solution where we can push between 300 and 400 million weather observations pr. Second into the database. We download date from NetCDF files. The date are joined based on t