17MAINTAINING YOUR DATABASE

image

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. But if you want to be a database administrator or a backend developer, the topics covered here are vital to both jobs.

It’s worth noting that database maintenance and performance tuning are often the subjects of entire books, and this chapter mainly serves as ...

Get Practical SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.