In the first two articles we examined vacuums, clusters and freeze. In this third and final piece we look at indexes and backups.
What are indexes and backups?
An index, like in a book, is a separate set of information that tells us what is where and saves having to re-read the whole book to find something. PostgreSQL uses indexes for a similar reason and broadly in a similar way.
Jane Silber is CEO of Canonical. Canonical produces Ubuntu, the leading open source platform for client, server and cloud computing. Canonical provides services to the IT industry to bring Ubuntu-based products to market, and to enterprise and consumer users to maximise their Ubuntu experience. Jane has over 20 years of business development, operations and software management experience.