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