Re: Postgres 10 disk space requirement compared to postgres 9.5.4

Поиск
Список
Период
Сортировка
От Sachin Singh
Тема Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Дата
Msg-id CAMc+PSqWh+u4yeDKpEbUYB5eDFRhmd2KO0_ZO9pY+HgwuYNkcQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 10 disk space requirement compared to postgres 9.5.4  (Debraj Manna <subharaj.manna@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi Debraj, 
I recently upgraded my postgres from 9.5 to 10.3 using pg_upgrade and it was smooth. There is no separate disk space requirement for migration of data .
Also before migration you can try "check " option for dry run of migration. (not actual migration , data will be untouched).Below is command
/usr/pgsql-10/bin/pg_upgrade --old-bindir=<> --new-bindir=<> --old-datadir=<> --new-datadir=<> --check

On Fri, Aug 3, 2018 at 9:38 AM Debraj Manna <subharaj.manna@gmail.com> wrote:
Yes.

 What will be the disk space requirement for space for same set of data in 9.5 and 10? I am asking this as I am guessing since we have to do data migration so there may be some change in data format.

On Fri 3 Aug, 2018, 9:34 AM suresh neravati, <suresh.neravati@yahoo.com> wrote:
Hi Debraj,

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


PostgreSQL: Documentation: 10: pg_upgrade



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,


--

 

To:



With Regards

Sachin

Contact: +91-8123183431
Email: notsachin@gmail.com
BANGLORE

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

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