Re: Postgres 10 disk space requirement compared to postgres 9.5.4

From: suresh neravati <suresh(dot)neravati(at)yahoo(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Date: 2018-08-03 04:04:57
Message-ID: 962124430.1421515.1533269097117@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

|
|
|
| | |

|

|
|
| |
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(dot)manna(at)gmail(dot)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,

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-08-03 04:07:42 Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Previous Message Debraj Manna 2018-08-03 03:57:26 Re: Postgres 10 disk space requirement compared to postgres 9.5.4