聚合函数并发计算
更新时间 2025-02-05 09:36:29
最近更新时间: 2025-02-05 09:36:29
本文介绍如何在使用SELECT语法时进行聚合函数并发计算。
teledb=# set max_parallel_workers_per_gather to 0;
SET
Time: 0.214 ms
teledb=# select count(1) from t_count;
count
----------
20000000
(1 row)
Time: 2700.569 ms (00:02.701)
teledb=# set max_parallel_workers_per_gather to 2;
SET
Time: 0.269 ms
teledb=# select count(1) from t_count;
count
----------
20000000
(1 row)
Time: 1867.719 ms (00:01.868)
