MENU
Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?
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
30 comments · newest first
VI
Vivan
6 months ago
I hope they don't ask tricky questions like this!
CU
Curtis
6 months ago
Exactly! If it's too low, it spills to disk.
MI
Micaela
6 months ago
A lot of sorting happens in memory, right?
CH
Chan
7 months ago
Yeah, I agree. It controls sort memory.
CA
Caitlin
7 months ago
I think it's B) work_mem.
RH
Rhea
7 months ago
Yeah, B) work_mem makes the most sense.
EL
Elvera
8 months ago
Wait, are you all sure about that?
HO
Hollis
8 months ago
I bet the correct answer is "All of the above, and then some." PostgreSQL loves its obscure settings!
IR
Irene
8 months ago
Hmm, I'm torn between B and C. Gotta love those PostgreSQL configuration parameters!
LI
Lisbeth
8 months ago
I'd go with C) maintenance_work_mem. Sounds like it could be related to sorting.
GE
Gertude
8 months ago
Definitely B. I've seen this one before in the PostgreSQL docs.
OW
Owen
8 months ago
B) work_mem is the correct answer.
RO
Ronnie
9 months ago
I feel like maintenance_work_mem is more for maintenance tasks, so it must be work_mem that controls sorting memory.
ON
Onita
9 months ago
I’m a bit confused; I thought temp_buffers had something to do with temporary files too, but I guess that’s not right for sorting?
PA
Page
9 months ago
I remember practicing a question about memory settings, and work_mem definitely came up as a key parameter for sorting operations.
YU
Yuonne
9 months ago
I think the parameter we're looking for is work_mem, but I’m not entirely sure if it’s the only one that affects sorting.
FR
Francis
9 months ago
B) work_mem, for sure. That's the parameter you want to look at to control the memory used for sorting operations in PostgreSQL.
WI
Willodean
9 months ago
I'm a little confused on this one. Is it B) work_mem or C) maintenance_work_mem? I know one of those controls memory for sorting, but I can't remember which one for sure.
VE
Veronika
10 months ago
Okay, I'm pretty confident the answer is B) work_mem. That's the parameter that sets the amount of memory to use for in-memory sorting before falling back to temporary disk files.
MA
Maybelle
10 months ago
I thought it was A) shared_buffers!
PO
Portia
10 months ago
It's B) work_mem for sure.
DE
Deonna
10 months ago
I was unsure at first, but B makes sense.
AL
Altha
10 months ago
Definitely B) work_mem, that's the one.
LO
Lourdes
11 months ago
Hmm, I'm not totally sure about this one. I know it has something to do with memory usage for sorting, but I can't remember which specific parameter controls that. I'll have to think it through.
NA
Nakisha
11 months ago
I think the answer is B) work_mem. That controls the amount of memory used for sorting before spilling to disk, right?
JE
Jenelle
5 months ago
B) work_mem is definitely the one for sorting!
CA
Carma
5 months ago
True, but that's for caching, not sorting.
MA
Madalyn
6 months ago
Isn't A) shared_buffers also related to memory?
KE
Kerry
6 months ago
Yeah, it makes sense for sorting operations.
AL
Aliza
6 months ago
I agree, B) work_mem sounds right.