Re: [ADMIN] Question about maintenance_work_mem and shared_buffer

2013-05-22 Thread Rodrigo Barboza
On Wed, May 22, 2013 at 6:14 AM, Albe Laurenz wrote: > 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?

Re: [ADMIN] Question about maintenance_work_mem and shared_buffer

2013-05-22 Thread Albe Laurenz
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

Re: [ADMIN] Question about maintenance_work_mem and shared_buffer

2013-05-21 Thread Rodrigo Barboza
On Tue, May 21, 2013 at 1:03 PM, Amit Langote wrote: > On Wed, May 22, 2013 at 12:07 AM, Rodrigo Barboza > wrote: > > Hi, everyone. > > 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. > >

Re: [ADMIN] Question about maintenance_work_mem and shared_buffer

2013-05-21 Thread Amit Langote
On Wed, May 22, 2013 at 12:07 AM, Rodrigo Barboza wrote: > Hi, everyone. > 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? They are ind

[ADMIN] Question about maintenance_work_mem and shared_buffer

2013-05-21 Thread Rodrigo Barboza
Hi, everyone. 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 sep