EnterpriseDB PostgreSQL-Essentials Exam - Topic 3 Question 11 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 11
Topic #: 3

[All PostgreSQL-Essentials Questions]

Which command reclaims all obsolete row space and compacts the customers table for reuse?

AVACUUM customers;

BVACUUM FULL customers;

CANALYZE customers;

DCLUSTER customers;

Show Suggested Answer

Suggested Answer: B

by Natalie at Mar 31, 2026, 09:43 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Refugia

I think it's B) VACUUM FULL customers. It really compacts the table.

upvoted 0 times

...

Catherin

5 days ago

I agree with B, it’s the most thorough option!

upvoted 0 times

...

Bettyann

10 days ago

Wait, does VACUUM FULL really reclaim all space? Sounds too good to be true!

upvoted 0 times

...

Nichelle

15 days ago

VACUUM FULL is the one that compacts, right?

upvoted 0 times

...

Mickie

2 months ago

I thought it was A) VACUUM customers?

upvoted 0 times

...

Willow

2 months ago

Definitely B) VACUUM FULL customers;

upvoted 0 times

...

Michal

3 months ago

CLUSTER customers sounds familiar, but I can't recall if it does the same thing as VACUUM FULL.

upvoted 0 times

...

Moon

3 months ago

I feel like ANALYZE customers is related to statistics, not reclaiming space.

upvoted 0 times

...

Ahmad

3 months ago

I remember practicing a similar question, and I think VACUUM is just for cleaning up space, not compacting.

upvoted 0 times

...

Gerald

3 months ago

I think it's B) VACUUM FULL customers, but I'm not entirely sure if it also compacts the table.

upvoted 0 times

...