I'm running PostgreSQL 16 on an AWS EC2 instance with 16 logical processors and 128G of RAM. How can I get PG to run the query with more workers?Postgres allocates more workers based on the log3 of the ratio of the table size to min_parallel_table_scan_size.
You may want to try |ALTER TABLE ... SET (parallel_workers = 10) (or whatever your desired value is).
|
