On: The One Billion Row Challenge

[ftisiot]

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/

[rustforlinux → ftisiot]

>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 → rustforlinux]

first run! I just rerun the experiment: - ~46 secs on the first run - ~22 secs on the following runs

[yencabulator → ftisiot]

Not including this in the benchmark time is cheating:

    \copy TEST(CITY, TEMPERATURE) FROM 'measurements.txt' DELIMITER ';' CSV;

[ftisiot → yencabulator]

The 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