On Wed, May 22, 2013 at 12:07 AM, Rodrigo Barboza <rodrigombu...@gmail.com> 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 independent settings. > If the 3 workers uses 1gb, will the database crash? Documentation does warn about not setting it (maintenance_work_mem) too high: "Note that when autovacuum runs, up to autovacuum_max_workers times this memory may be allocated, so be careful not to set the default value too high." http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html -- Amit Langote -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
