Database Management PostgreSQL Subjective
Sep 25, 2025

Explain PostgreSQL tablespaces and their benefits.

Detailed Explanation

Tablespaces allow database administrators to define locations in the file system where database objects can be stored.

Benefits:
• Storage management across multiple disks
• Performance optimization
• Administrative flexibility
• Space allocation control

Example:

CREATE TABLESPACE fast_storage LOCATION '/ssd/postgres';
CREATE TABLE users (...) TABLESPACE fast_storage;

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback