Re: Moving a table/index to different tablespace

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving a table/index to different tablespace
Date: 2020-12-04 02:19:37
Message-ID: 20201204021937.GA16616@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2020-Dec-03, Yambu wrote:

> Hi
>
> May i know if there is any risk in moving a table or index to a different
> tablespace during usage?

There's no risk as such, but an access exclusive lock will be acquired
during the move, which will prevent all other access to that table or
index.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-12-04 06:27:22 Adding another cluster on same machine
Previous Message Ron 2020-12-03 21:27:32 Re: deactivate user accounts not used within the last 90 days.