On 05/23/2014 08:57 AM, Vincent de Phily wrote:
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive lock on the table for the 2h it'll take to
> copy the data.
You might look at pg_repack (https://github.com/reorg/pg_repack). The
most recent version added the ability to repack a table (or just
indexes) to a new tablespace. It won't be fast as it will essentially
rebuild the entire table. But it only needs an exclusive lock for a
brief moment, so there's virtually zero down time and no data loss.
- Chris