Re: Reorganizing a database objects

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Reorganizing a database objects
Date: 2011-08-08 17:29:12
Message-ID: 201108081029.12528.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On August 8, 2011 10:06:43 AM JORGE MALDONADO wrote:
> Should I
> create a new DB that reference such new locations (Tablespaces), backup
> the original one and restore it to the new one?

You can ALTER a table or index to change its tablespace.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2011-08-08 22:09:30 Moving a PostgreSQL database to a new tablespace
Previous Message JORGE MALDONADO 2011-08-08 17:06:43 Reorganizing a database objects