3 ms·
Just modified the original post to add the file_fdw. Again, none of the instances (PG or ClickHouse) were optimised for the workload https://ftisiot.net/posts/1
by ftisiot 3y ago
Just modified the original post to add the file_fdw. Again, none of the instances (PG or ClickHouse) were optimised for the workload https://ftisiot.net/posts/1brows/ https://ftisiot.net/posts/1brows/
- yencabulator 3y agoNot including this in the benchmark time is cheating: \copy TEST(CITY, TEMPERATURE) FROM 'measurements.txt' DELIMITER ';' CSV;
- ftisiot 3y agoThe loading time it's included in both examples In the first one, the table is dropped, recreated, populated and queries. In the second example, the table is created from a file FDW to the CSV file. In both examples the loading time is included in the total time
- rustforlinux 3y ago>The result is 44.465s! Very nice! Is this time for the first run or second? Is there a big difference between the first and second run, please?
- ftisiot 3y agofirst run! I just rerun the experiment: - ~46 secs on the first run - ~22 secs on the following runs