Rodrigo Barboza wrote: > I have a doubt. > I have a 32-bit postrgesql running with 2.5gb of shared_buffer. > And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3. > How maintenance_work_mem is related to shared_buffer? > If the 3 workers uses 1gb, will the database crash? > Or their memory usage are separated from each other?
Your doubt is quite in place, as a process on a 32-bit architecture cannot address more than 4GB of memory.