Re: Postgres 10 disk space requirement compared to postgres 9.5.4

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

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(dot)neravati(at)yahoo(dot)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
> <https://www.postgresql.org/docs/10/static/pgupgrade.html>
>
> PostgreSQL: Documentation: 10: pg_upgrade
>
> <https://www.postgresql.org/docs/10/static/pgupgrade.html>
>
>
> 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 Ron 2018-08-03 04:08:27 Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Previous Message suresh neravati 2018-08-03 04:04:57 Re: Postgres 10 disk space requirement compared to postgres 9.5.4