Re: New tablespace: just an advice

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: New tablespace: just an advice
Дата
Msg-id 2575708954513e34667ad6404b5237377902e573.camel@cybertec.at
обсуждение исходный текст
Ответ на New tablespace: just an advice  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Ответы Re: New tablespace: just an advice  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Список pgsql-general
Moreno Andreo wrote:
> Now, 2 questions.
> 1. Is it all or do I need to adjust something else about permissions, 
> indexes, vacuuming, etc...?
> ALTERing the database namespace means copying its physical files to new 
> directory, but is it applied to all objects (indexes, triggers, etc)?

All objects that are located in the default tablespace of the database
will be moved.

> 2. What will happen to who tries to access the database while it's being 
> moved from one tablespace to another?

They will be "hanging" with a lock until the transaction is done.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Colin Coles
Дата:
Сообщение: Re: Problem creating a database
Следующее
От: Nicola Contu
Дата:
Сообщение: Swap on postgres master server