3 ms·
Yes, setting between Hydra and Postgres (tuned) are somehow aligned. But what Postgres (tuned) also creates are bunch of indexes (https://github.com/ClickHouse/
by _nvp 3y ago
Yes, setting between Hydra and Postgres (tuned) are somehow aligned. But what Postgres (tuned) also creates are bunch of indexes (https://github.com/ClickHouse/ClickBench/blob/main/postgresql-tuned/index.sql https://github.com/ClickHouse/ClickBench/blob/main/postgresq...) which adds around ~50GB of extra storage.
- tomnipotent 3y agoEquivalent settings makes the comparison more useful, and storage-conscious readers will pick-up that Postgres uses 4-6x more.
- _nvp 3y agoAgree, but also, IMO, using index is what gives also performance boost. Just looking at queries that use string search - they have best result overall in complete test. Postgres (tuned) is designed for this specific clickbench table and nothing wrong with that.
- riku_iki 3y ago> Yes, setting between Hydra and Postgres (tuned) are somehow aligned. very somehow, since Hydra essentially is allowed to use 4 times more CPU cores.