Re: Moving a table/index to different tablespace - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Moving a table/index to different tablespace
Date
Msg-id 20201204021937.GA16616@alvherre.pgsql
Whole thread Raw
In response to Moving a table/index to different tablespace  (Yambu <hyambu@gmail.com>)
List 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.



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: deactivate user accounts not used within the last 90 days.
Next
From: Yambu
Date:
Subject: Adding another cluster on same machine