3 ms·
What makes postgres special in these cases?
by reasonabl_human 6y ago
What makes postgres special in these cases?
- chmod775 6y agoI would like to know as well. All I know is that for this specific workload there appears to be a strong correlation between the chosen DB and performance. Depending on the benchmark you're looking at on that site, the top 30-60 results are exclusively postgres. Further, for every framework/language that was tested with both MySQL and postgres (there's quite a few of them), the postgres one always ranks higher.
- est 6y ago> the top 30-60 results are exclusively postgres. Perhaps it's because pg had better async drivers?
- ahoka 6y ago"In this test, the framework's ORM is used to fetch all rows from a database table containing an unknown number of Unix fortune cookie messages (the table has 12 rows, but the code cannot have foreknowledge of the table's size)." This is the "workload".
- edoceo 6y agoLikely it's the better/faster support for multi-step transactions. (That's a big point for PG, since at least 2004)