From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
Date: Thu, 2 Aug 2018 23:08:27 -0500
Message-ID: <b69f1150-bd4e-9533-a41b-de98e77ee6a8@gmail.com> (raw)
In-Reply-To: <962124430.1421515.1533269097117@mail.yahoo.com>
References: <CAF6DVKM_MV5AvDk2BgY_Ai83vu6j2j3qR7-N2xqR3xOK0__YoQ@mail.gmail.com>
<962124430.1421515.1533269097117@mail.yahoo.com>
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.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,
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4
In-Reply-To: <b69f1150-bd4e-9533-a41b-de98e77ee6a8@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox