pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMoving a table/index to different tablespace
2+ messages / 2 participants
[nested] [flat]
* Moving a table/index to different tablespace
@ 2020-12-03 18:28 Yambu <hyambu@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Yambu @ 2020-12-03 18:28 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi
May i know if there is any risk in moving a table or index to a different
tablespace during usage?
regards
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Moving a table/index to different tablespace
@ 2020-12-04 02:19 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Yambu <hyambu@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2020-12-04 02:19 UTC (permalink / raw)
To: Yambu <hyambu@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-12-04 02:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-03 18:28 Moving a table/index to different tablespace Yambu <hyambu@gmail.com>
2020-12-04 02:19 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox