Home > mailing lists

Question about maintenance_work_mem and shared_buffer - Mailing list pgsql-admin

From	Rodrigo Barboza
Subject	Question about maintenance_work_mem and shared_buffer
Date	May 21, 2013 18:07:43
Msg-id	CANs8QJbjeMREKsBAQNmKThU5ppYeB_apsmsWvdYOkii6cn56eQ@mail.gmail.com Whole thread Raw
Responses	Re: Question about maintenance_work_mem and shared_buffer (Amit Langote <amitlangote09@gmail.com>) Re: Question about maintenance_work_mem and shared_buffer (Albe Laurenz <laurenz.albe@wien.gv.at>)
List	pgsql-admin

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 separated from each other?

From: "McKinzie, Alan (Alan)"
Date: 21 May 2013, 15:05:11
Subject: Re: pg_restore

From: Amit Langote
Date: 21 May 2013, 19:03:37
Subject: Re: Question about maintenance_work_mem and shared_buffer