EnterpriseDB PostgreSQL-Essentials Exam - Topic 3 Question 11 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 11
Topic #: 3

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

Contribute your Thoughts:

Submit Cancel

18 days ago

I thought it was A) VACUUM customers?

upvoted 0 times

...

23 days ago

Definitely B) VACUUM FULL customers;

upvoted 0 times

...

1 month ago

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

upvoted 0 times

...

2 months ago

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

upvoted 0 times

...

2 months ago

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

upvoted 0 times

...

2 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

...