Re: Postgres 10 disk space requirement compared to postgres 9.5.4

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Дата
Msg-id b69f1150-bd4e-9533-a41b-de98e77ee6a8@gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 10 disk space requirement compared to postgres 9.5.4  (suresh neravati <suresh.neravati@yahoo.com>)
Список pgsql-admin
How fast is fast?  Does it need to rewrite all the data (would take a while on a Really Large Database), or just change a bit of metadata?

On 08/02/2018 11:04 PM, suresh neravati wrote:
Hi Debraj,

You can use pg_upgrade utility from Postgresql.  This works with inplace option.  Look at this link below for more details.




This option is also be the fastest for upgrading from 9.5 to PG10

Thanks,
Suresh Neravati

On Thursday, August 2, 2018, 7:28:47 AM PDT, Debraj Manna <subharaj.manna@gmail.com> wrote:


Hi

On moving from postgres 9.5.4 to postgres 10.x we have to do data migration. 

Can some one let me know will the disk space requirement remain same for same set of tables with same number of rows in postgres 10.x and postgres 9.5.4 ?

Thanks,

--
Angular momentum makes the world go 'round.

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

Предыдущее
От: Debraj Manna
Дата:
Сообщение: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Следующее
От: suresh neravati
Дата:
Сообщение: Re: Postgres 10 disk space requirement compared to postgres 9.5.4