Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 10 disk space requirement compared to postgres 9.5.4 - Mailing list pgsql-admin

From Debraj Manna
Subject Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Date
Msg-id CAF6DVKNKO_7tS-LWv53jDm4MXoY=fRzsViJztjJGVsstoi7xHw@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 10 disk space requirement compared to postgres 9.5.4  (suresh neravati <suresh.neravati@yahoo.com>)
Responses Re: Postgres 10 disk space requirement compared to postgres 9.5.4  (Sachin Singh <notsachin@gmail.com>)
List pgsql-admin
Tree view
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.




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,

pgsql-admin by date:

Previous
From: suresh neravati
Date:
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Next
From: Ron
Date:
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4