MENU
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
Suggested Answer: B
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
17 comments · newest first
FA
Fallon
23 days ago
I’m leaning towards B too. It’s all about maintenance!
SH
Sherron
28 days ago
B) maintenance_work_mem is crucial for performance.
PE
Percy
1 month ago
I thought it was A) work_mem at first, but B fits better.
BR
Bronwyn
1 month ago
I remember reading about this. B is the right choice!
MA
Malinda
1 month ago
Definitely B) maintenance_work_mem. It’s specifically for maintenance.
NY
Nydia
2 months ago
I feel unsure about this one.
ST
Stephanie
2 months ago
Agreed! It makes sense for maintenance tasks.
GL
Glenn
2 months ago
I think it's B) maintenance_work_mem.
SH
Sheridan
2 months ago
I don't think temp_buffers has anything to do with maintenance.
LA
Latanya
2 months ago
Wait, is there really a parameter called vacuum_mem? Sounds odd.
FI
Filiberto
2 months ago
Agreed, B is the right one!
CH
Charlesetta
3 months ago
I thought it was A) work_mem at first!
JA
Janna
3 months ago
It's definitely B) maintenance_work_mem.
WI
Wilbert
3 months ago
I’m confused! I thought vacuum operations used a different parameter, but I can’t recall which one. Maybe it’s C) vacuum_mem?
VI
Virgina
3 months ago
I’m leaning towards B) maintenance_work_mem too, but I keep mixing it up with temp_buffers.
SH
Shaun
3 months ago
I feel like I’ve seen a question like this before, and I think it was about memory settings. Could it be A) work_mem instead?
RE
Renea
4 months ago
I think it's B) maintenance_work_mem, but I’m not entirely sure. I remember it being related to maintenance tasks.