Re: Postgres 10 disk space requirement compared to postgres 9.5.4

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Date: 2018-08-03 04:08:27
Message-ID: b69f1150-bd4e-9533-a41b-de98e77ee6a8@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
>
> 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,

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

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