I would like to migrate timestamp data (about 500 millions of rows) from PostgreSQL to InfluxDB.
I use ReseltSet to read data from Postgres and java client (influxdb-java) to write points in InfluxDB (row by row). It’s only one measurement (One Table). To write the data to InfluxDB I also use a method influxDB.enableBatch(2000, 100, TimeUnit.MILLISECONDS).
In practice, I see that the InfluxDB write the points very slowly, only 500K in a day (around 30 points in a sec). With this performance, I need the whole year to copy my data.
- Is there any possibility to write data into InfluxDB faster?
- How many points in a sec. can I write theoretical to InfluxDB?
Thank you in advance!
P.S. I use Apple Mac mini - Core, which ist not real powerful.