Re: How to query with more workers on a large table with many partitions

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).