Hi PostgreSQL community, I have a large table (86 GB) that is declaratively partitioned by year, sub-partitioned by month, and sub-sub-partitioned by day. It currently has 437 leaf partitions, and will continue to grow with a new partition each day. When I query a simple count(*) by date, the query planner plans a query with five workers, but I have the following in postgresql.conf:
max_worker_processes = 12 max_parallel_workers_per_gather = 12 max_parallel_workers = 12 shared_buffers = 32GB temp_buffers = 1GB work_mem = 512MB The top-level partitioned table has been ANALYZEd. 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? Thank you, Gabriel
