Re: Rearchitecting for storage

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Rearchitecting for storage
Дата
Msg-id 20190719152512.cxys4djc4ie6i2ux@hjp.at
обсуждение исходный текст
Ответ на Re: Rearchitecting for storage  (Matthew Pounsett <matt@conundrum.com>)
Ответы Re: Rearchitecting for storage  (Matthew Pounsett <matt@conundrum.com>)
Список pgsql-general
On 2019-07-19 10:41:31 -0400, Matthew Pounsett wrote:
> Okay.  So I guess the short answer is no, nobody really knows how to
> judge how much space is required for an upgrade?  :)

As I understand it, a pg_upgrade --link uses only negligible extra
space. It duplicates a bit of householding information, but not your
data tables or indexes. Your 18 TB table will definitely not be duplicated
during the upgrade if you can use --link.

        hp

--
   _  | Peter J. Holzer    | we build much bigger, better disasters now
|_|_) |                    | because we have much more sophisticated
| |   | hjp@hjp.at         | management tools.
__/   | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>

Вложения

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

Предыдущее
От: Matthew Pounsett
Дата:
Сообщение: Re: Rearchitecting for storage
Следующее
От: Matthew Pounsett
Дата:
Сообщение: Re: Rearchitecting for storage