Hello,
On Sun, Oct 13, 2024 at 08:16:04AM +1300, Thomas Munro wrote:
> > template1=> SELECT COUNT(*) FROM pg_class a, pg_class b, pg_class c;
> >
> > I see only one 100% CPU PostgreSQL process.
>
> If you set set min_parallel_table_scan_size = 0 then it uses
Without it, it uses one CPU and takes
On Sun, Oct 13, 2024 at 6:31 AM Marc SCHAEFER
wrote:
> template1=> SELECT COUNT(*) FROM pg_class a, pg_class b, pg_class c;
>
> I see only one 100% CPU PostgreSQL process.
If you set set min_parallel_table_scan_size = 0 then it uses
parallelism, and completes much faster. The planner generally w
Hello,
on a machine where starting two processes:
perl -e 'while (1) { ; }'
I see two processed at 100% CPU, which is expected (with top).
Now, if I do:
template1=> SELECT COUNT(*) FROM pg_class a, pg_class b, pg_class c;
I see only one 100% CPU PostgreSQL process.
I read that while Postgre
