| From: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: New tablespace: just an advice |
| Date: | 2018-10-16 09:13:31 |
| Message-ID: | 39c299c7-9c10-ebe9-8841-68560c9e8deb@evolu-s.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Il 16/10/2018 10:18, Laurenz Albe ha scritto:
> 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
Perfect!
Thanks for your time,
Moreno
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans Schou | 2018-10-16 09:18:19 | Re: Swap on postgres master server |
| Previous Message | Nicola Contu | 2018-10-16 09:04:20 | Swap on postgres master server |