maintenance_work_mem
value of 64MB
is quite conservative and can slow down parallel index builds. We recommend at least 64MB
per
parallel worker.
15MB
memory. If maintenance_work_mem
is set too low, an error will be returned.
max_parallel_maintenance_workers
setting to determine the degree of parallelism during CREATE INDEX
/REINDEX
. Postgres’ default is 2
, which may be too low for large tables.
max_parallel_maintenance_workers
to take effect, it must be less than or equal to both max_parallel_workers
and max_worker_processes
.