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
