O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Regular Maintenance

In this chapter, we will cover the following:

  • Controlling automatic database maintenance
  • Avoiding auto freezing and page corruptions
  • Avoiding transaction wraparound
  • Removing old prepared transactions
  • Actions for heavy users of temporary tables
  • Identifying and fixing bloated tables and indexes
  • Maintaining indexes
  • Finding unused indexes
  • Carefully removing unwanted indexes
  • Planning maintenance

Introduction

PostgreSQL prefers regular maintenance, and there is a recipe discussing planning maintenance.

We recognize that you're here for a reason and are looking for a quick solution to your needs. You're probably thinking fix me first and I'll plan later. So off we go.

PostgreSQL provides a utility command named VACUUM, which is a jokey ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required