Hi,
I am completely new to Yugabyte and have just downloaded the latest docker image for a test.
Following the quick start guide for docker I ran the aggregation test query:
yb_demo=# SELECT source, ROUND(SUM(orders.total)) AS total_sales
FROM users, orders WHERE users.id=orders.user_id
GROUP BY source
ORDER BY total_sales DESC;
On my test system (a laptop with 16G running Ubuntu 20.04) the query took more than 12 seconds. I use the same test data on a postgresql instance on the same system, and the query took only 0.1s.
How is this huge performance difference to be explained? Surely something is wrong with my setup but I have just followed the quick start guide.