6 ms·
Thank you for reading and for your kind words! Ah I did not know about the `create_default_indexes=>false` and that a time index is created by default for hype
by PolarizedPoutin 2y ago
Thank you for reading and for your kind words!
Ah I did not know about the `create_default_indexes=>false` and that a time index is created by default for hypertables. I'll add a note to explain this! Also curious to benchmark inserting without the time index then creating it manually.
Even with 32 workers I think the HDD was fine. I did monitor disk usage through btop and the SSD that Postgres lived on seemed to be more of a bottleneck than the HDD. So my conclusion was that a faster SSD for Postgres would be a better investment than moving the data from HDD to SSD.