Poor performance for aggregation queries on sample data

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)