Re: maintenance_work_mem impact?

On Tue, 2024-03-19 at 16:05 +, Adithya Kumaranchath wrote: > I have a table approx. 20GB. > > CREATE UNIQUE INDEX testindex_v1 ON testtable1 (test_index);  > > My observations: > maintenance_work_mem = 2G > max_parallel_workers = '16' > > The create index completes in 20 minutes. > > When I

maintenance_work_mem impact?

Hi all, I have a table approx. 20GB. I have a create unique index statement. CREATE UNIQUE INDEX testindex_v1 ON testtable1 (test_index); My observations: maintenance_work_mem = 2G max_parallel_workers = '16' The create index completes in 20 minutes. When I change this: maintenance_work_mem =