EnterpriseDB PostgreSQL-Essentials Exam - Topic 9 Question 4 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 4
Topic #: 9

Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?

Ashared_buffers

Bwork_mem

Cmaintenance_work_mem

Dtemp_buffers

Show Suggested Answer

Suggested Answer: B

by Bettina at Nov 22, 2025, 05:24 AM

Limited Time Offer

25%

Off

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Elvera

9 hours ago

Wait, are you all sure about that?

upvoted 0 times

...

Hollis

6 days ago

I bet the correct answer is "All of the above, and then some." PostgreSQL loves its obscure settings!

upvoted 0 times

...

Irene

11 days ago

Hmm, I'm torn between B and C. Gotta love those PostgreSQL configuration parameters!

upvoted 0 times

...

Lisbeth

16 days ago

I'd go with C) maintenance_work_mem. Sounds like it could be related to sorting.

upvoted 0 times

...

Gertude

21 days ago

Definitely B. I've seen this one before in the PostgreSQL docs.

upvoted 0 times

...

Owen

26 days ago

B) work_mem is the correct answer.

upvoted 0 times

...

Ronnie

1 month ago

I feel like maintenance_work_mem is more for maintenance tasks, so it must be work_mem that controls sorting memory.

upvoted 0 times

...

Onita

1 month 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?

upvoted 0 times

...

Page

1 month ago

I remember practicing a question about memory settings, and work_mem definitely came up as a key parameter for sorting operations.

upvoted 0 times

...

Yuonne

2 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.

upvoted 0 times

...

Francis

2 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.

upvoted 0 times

...

Willodean

2 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.

upvoted 0 times

...

Veronika

2 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.

upvoted 0 times

...

Maybelle

2 months ago

I thought it was A) shared_buffers!

upvoted 0 times

...

Portia

2 months ago

It's B) work_mem for sure.

upvoted 0 times

...

Deonna

3 months ago

I was unsure at first, but B makes sense.

upvoted 0 times

...

Altha

3 months ago

Definitely B) work_mem, that's the one.

upvoted 0 times

...

Lourdes

3 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.

upvoted 0 times

...

Nakisha

3 months ago

I think the answer is B) work_mem. That controls the amount of memory used for sorting before spilling to disk, right?

upvoted 0 times

...