Re: Bloated pg_shdepend_depender_index

Поиск
Список
Период
Сортировка
От Ola Sandbu
Тема Re: Bloated pg_shdepend_depender_index
Дата
Msg-id 442A7FC3.4060600@usit.uio.no
обсуждение исходный текст
Ответ на Re: Bloated pg_shdepend_depender_index  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Список pgsql-admin

Andy Shellam wrote:
> This is true, but you could run the new version on the same server/different
> port to the current version, and do a simultaneous dump/restore without
> having to use extra disk space, or taking your production database offline -
> then you can schedule a time to kill the old one, re-assign the port on the
> new one and bring it up - would take about 30 seconds, and this could be
> done at a time when traffic was at its lowest.
>

Hmmm - Interesting solution!
Does you know of anybody that have tried an upgrade migration like this,
and experience with very large databases?

--
-------------------------------------
Ola Sandbu       tel: (+47)22840197
USIT/SAPP-DBA    mob: (+47)91594704
mailto:Ola.Sandbu@usit.uio.no
-------------------------------------

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

Предыдущее
От: "Andy Shellam"
Дата:
Сообщение: Re: FW: Setting up of PITR system.
Следующее
От: "Rajesh Kumar Mallah"
Дата:
Сообщение: Re: FW: Setting up of PITR system.