Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1flRKv-0006eg-GO for pgsql-admin@arkaria.postgresql.org; Fri, 03 Aug 2018 04:05:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1flRKt-0001kH-Es for pgsql-admin@arkaria.postgresql.org; Fri, 03 Aug 2018 04:05:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1flRKr-0001kA-KV for pgsql-admin@lists.postgresql.org; Fri, 03 Aug 2018 04:05:07 +0000 Received: from sonic315-15.consmr.mail.bf2.yahoo.com ([74.6.134.125]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1flRKo-0003g4-O2 for pgsql-admin@postgresql.org; Fri, 03 Aug 2018 04:05:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1533269098; bh=5dp+AmyvO8mo7Kb9MswY/WB+zMu86FPuyTgqkiw/KYw=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=EoXrOcHFsBwBOSTQRiviz97JibdOlO6zxwDlonsGHbA/Y+4Bd6h/HXbzaNDxzCeLbmk1Oa10zSR1v8irzV0jrvFsm/5uAX4Z7vpduHtfvGCtw6w8V0QzD946PXBEXIl6zYBZpDa5/qOH1qjcplkZg7Db874r4LohkzrizdJnsDeqLIbtdtvmTD1yr6paV9ShY3JsL96ywhxkaKlFL6CBYRhwih7fMe0ZLh2yvLy88/wWUYsaq8vnxqaPGlZQzumeF5X3hHkHos4uWv5eezaEMnSzLFgSbiVty7kOQZ2eRpr9v/VM+daEjm/vPNvvk3LClTnMvD/lu42c9zv9AgjWRw== X-YMail-OSG: sct7RPsVM1niWwbQFg3MLglbqKDNrl7nvsLDBCYq3_yfWE43.S9H7g6zrYrvuld y9noUOJSxZxna_buqafScuo.v4Q8O1mePGnZyi0.rVZ1rrouj4Djxh3EdaweYjNPg7alA3ni1eMX f_NHHbeklJpcOhB3WrCqFTFYOtdw86OHrdUdAT.xNAEQ8gQNIY4NBW.NnlRKZs0T2VAYnj7u3895 3YoPSuuJqtCnYAN2lOcFnrc.b48WadiFOOa91UHIUAbxrgPk1fkjDkvrJAIphFtiyBiVVhk_6fwu hVCDZNtUmsVfgsPckzGS5MdZbulJAcnPUPlOscuxSjPosuLDz8mCWbpdmcZZWIjMLphflLrCpiOH WfWafa.0GipUEkBIYre0cpH2zyxuSD73PCLF.REIvOXQEzZ3u7eSR6pkaIjpUimAT9uome3eG9_y 0cktpJDswGLYnT2bY9h1t_EQlTC.recytCIepZ8XdgqVSqwW0E02_uFkD3Zm3QHdkZJVxUI9zk9n q3bmYlHBckP3PUcgVMJPTpUFR5_djRIfS9En4pzhkeUspxrYgHCLjlBBG8cuKhCNYrVl0EK9p.FC _IsvrbcXg4H1_F2gvSs2dJ_xzfMkhkGd5yBgdc.XFP25pgOEbuKjNso2ZPoCYg4tA_jn01zfP4py MvcRZRYsBouEwTqMjS0SiuB3iDqYJ2CA1ov78G.n42MWlGa45uQCppIVqdtW.JxozdLnrjRRxZs9 5CuchCj2EtoFhCYrCm9pD6pAMP_ixHeFDRek94l63M37_yfd4QjhBZ4ur0OufqXJocQIcQN5V2Wm PkDZAsu4AhFk.m2kUHoXA__1rERb0F.296Ftj8DZ28lP2oLGL7e84b_7wdr_QM11OAUTKgOZihV7 NizvGR78e9LYDscM.OGU5jRzK67qH39IS0OiJhAWJw79Ygau4bQNKhfyc3uNvRL3Sd8H1JLieJiO hTz8GTxWeXlq1a3RxSR9wrqkGBahvrPzastU2eur.ykt7sKn1 Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Fri, 3 Aug 2018 04:04:58 +0000 Date: Fri, 3 Aug 2018 04:04:57 +0000 (UTC) From: suresh neravati To: pgsql-admin , Debraj Manna Message-ID: <962124430.1421515.1533269097117@mail.yahoo.com> In-Reply-To: References: Subject: Re: Postgres 10 disk space requirement compared to postgres 9.5.4 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1421514_1142090174.1533269097115" X-Mailer: WebService/1.1.12206 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0 Content-Length: 7587 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1421514_1142090174.1533269097115 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Debraj, You can use pg_upgrade utility from Postgresql.=C2=A0 This works with inpla= ce option.=C2=A0 Look at this link below for more details. PostgreSQL: Documentation: 10: pg_upgrade |=20 |=20 |=20 | | | | | |=20 | |=20 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 wrote: =20 =20 Hi On moving from postgres 9.5.4 to postgres 10.x we have to do data migration= .=C2=A0 Can some one let me know will the disk space requirement remain same for sa= me set of tables with same number of rows in postgres 10.x and postgres 9.5= .4 ? Thanks, =20 ------=_Part_1421514_1142090174.1533269097115 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable