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

Adding/Removing tablespaces

Tablespaces allow us to store PostgreSQL data across different devices. We might want to do that for performance, administrative ease, or your database might just have run out of disk space.

Getting ready

Before we can create a useful tablespace, we need to prepare the underlying devices in production-ready form.

Think carefully about the speed, volume, and robustness of the disks you are about to use. Make sure they are configured correctly. Those decisions will affect your life for the next few months and years.

Disk performance is a subtle issue that most people think can be decided in a few seconds. We recommend you read the Performance section of this book, as well as additional books on this topic.

Once you've done ...

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