19 Maintaining Your Database
To wrap up our exploration of SQL, we’ll look at key database maintenance tasks and options for customizing PostgreSQL. In this chapter, you’ll learn how to track and conserve space in your databases, how to change system settings, and how to back up and restore databases. How often you’ll need to perform these tasks depends on your current role and interests. If you want to be a database administrator or a backend developer, the topics covered here are vital.
It’s worth noting that database maintenance and performance tuning are large enough topics that they often occupy entire books, and this chapter mainly ...
Get Practical SQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
