2 ms·

Clickbench is single-table. Do you have a join story?

• wuputah 4y ago
  Of course, that's the power of Postgres. You can join between columnar tables or between columnar and heap (row-based) tables. The performance of joins hasn't been a specific focus of our engineering work yet, but I made a little test of enriching an analytical query with user data here: https://gist.github.com/wuputah/e62b83f86880bd7e6623809afe4c1e41 https://gist.github.com/wuputah/e62b83f86880bd7e6623809afe4c...