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 the O’Reilly learning platform.

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