Request a Demo
Home   >   mailing lists

Re: How to query with more workers on a large table with many partitions - Mailing list pgsql-general

From Greg Hennessy
Subject Re: How to query with more workers on a large table with many partitions
Date
Msg-id 0b2865ee-b220-48c1-9314-86aa34048503@gmail.com
Whole thread Raw
In response to How to query with more workers on a large table with many partitions  (Gabriel Sánchez <gabrielesanchez@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Gabriel Sánchez
Date:
Subject: Speeding up ANALYZE on large partitioned tables
Next
From: Adrian Klaver
Date:
Subject: Re: malformated LSB header in postgres: missing LSB end marker, aborting