Question about maintenance_work_mem and shared_buffer

Поиск

Список

Период

Сортировка

От	Rodrigo Barboza
Тема	Question about maintenance_work_mem and shared_buffer
Дата	21 мая 2013 г. 18:07:43
Msg-id	CANs8QJbjeMREKsBAQNmKThU5ppYeB_apsmsWvdYOkii6cn56eQ@mail.gmail.com обсуждение исходный текст
Ответы	Re: Question about maintenance_work_mem and shared_buffer Re: Question about maintenance_work_mem and shared_buffer
Список	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?

В списке pgsql-admin по дате отправления:

От: "McKinzie, Alan (Alan)"
Дата: 21 мая 2013 г., 15:05:11
Сообщение: Re: pg_restore

От: Amit Langote
Дата: 21 мая 2013 г., 19:03:37
Сообщение: Re: Question about maintenance_work_mem and shared_buffer