Hi @Yuan_Hong
I just tried the same with my setup (16gb laptop, ubuntu 18.04, i7,ssd). The aggregate query finished in 3-4 seconds. Are you testing from ysqlsh
with \timing
? If not, can you try that and report back ?
yb_colocated=# SELECT source, ROUND(SUM(orders.total)) AS total_sales
yb_colocated-# FROM users, orders WHERE users.id=orders.user_id
yb_colocated-# GROUP BY source
yb_colocated-# ORDER BY total_sales DESC;
source | total_sales
-----------+-------------
Facebook | 333454
Google | 325184
Organic | 319637
Twitter | 319449
Affiliate | 297605
(5 rows)
Time: 3980.298 ms (00:03.980)