| ▲ | throwaway7783 3 hours ago | |
This is a great project. Thank you! A question on 20s postgresql time - It does not look like you are accounting for reading data from disk? Wouldn't the aggregation query have to load data from disk first? Or is it somewhat guaranteed that the table is already in memory? The Rust version is clearly in memory (I am no rust expert, so that may not even be actually in memory, if its a generator). | ||
| ▲ | malisper 3 hours ago | parent [-] | |
> A question on 20s postgresql time - It does not look like you are accounting for reading data from disk I choose the data size so that it would fit in memory on the machine I was testing on. fwiw, there's still a ton of overhead Postgres has that the toy example does not. For example Postgres will serialize the numbers into tuples and need to deserialize them to execute the query. That's why it's not an apples-to-apples comparison | ||