Date: Tue, 26 Jul 2016 19:11:29 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Jerry Sievers <gsievers19@comcast.net>, pgsql-admin@postgresql.org
Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending
 UNlogged data?
Message-ID: <20160726231129.GH4028@tamriel.snowman.net>
References: <86d1m5b6bi.fsf@jerry.enova.com>
 <20160725163700.GZ4028@tamriel.snowman.net>
 <20160725164329.GA4028@tamriel.snowman.net>
 <86eg6hr58q.fsf@jerry.enova.com>
 <20160726161946.GA3511@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="c4ATLI8HJzklxeaH"
Content-Disposition: inline
In-Reply-To: <20160726161946.GA3511@momjian.us>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--c4ATLI8HJzklxeaH
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Bruce Momjian (bruce@momjian.us) wrote:
> On Mon, Jul 25, 2016 at 12:34:45PM -0500, Jerry Sievers wrote:
> > Stephen Frost <sfrost@snowman.net> writes:
> >=20
> > > * Stephen Frost (sfrost@snowman.net) wrote:
> > >
> > >> > I have among others, a 5TB system  w/about 40G of unlogged data.
> > >>=20
> > >> Honestly, sending an extra 40G out of 5TB (we're talking less than 1%
> > >> here...) might be worth it to keep the process simple.
> > >
> > > Of course, I realize right after sending this that you aren't sending
> > > the 5TB. :)
> >=20
> > Roger that!  Really, the hard link pg-upgrade option and rsync method
> > for standbys is pure beauty :-)
> >=20
> > We have only the post-analyze and this unlogged data  problem to deal
> > with.=20
> >=20
> > The warehouse is our only system with any substantial amount of unlogged
> > data.
> >=20
> > Reducing post-analyze delay was solved by me here with our groovy
> > threaded AnalyzMaTron.  I can get a >5TB system done in about 45 minutes
> > w/20 threads.
>=20
> The only thing I can suggest is to document this limitation, if people
> think it is worth it.

It'd probably be good to document what happens with unlogged tables.

Thanks!

Stephen

--c4ATLI8HJzklxeaH
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJXl+4hAAoJEO1sijiDR2RVAx4P/2edKR+Fll3+86Fy9Cytnrjn
4iP7uxe7nm4nC6oBdN0fdN5mWu5NHULu4+w/jnZeFueYJtqRTjCZjUHpKlESQbD2
+LwQpBQfNY+A7bj5M+X1NG5YUoS3mNWmYxV7C6g1dyDLXFPvIyNUCq3d+Af5h9n/
oRybescMlKUgSMQ0QNvX8EYQVkSn8TgLBq1c2Y1Lbo3iD5ReVKuVY2xSM7pgBYdF
DEoDHdmfgD/I/srMJX+CuITHNmbvOcHBtnf035LA+6AHNmYIuTAPrVPOrJmgkjPk
ptNmPoQWohoTwC9quV8y7sv7sgYltzWX10BiHlhemlCPpRpkc7XYQIkRx52Er59K
OHnXsC92vH+QkcvKw7ksqa2/dQGPP9wG6aZh2/xewkxmE34F0ByFzgxuPqkUt9d8
90PqOvJxVgJUw6x0FQ4Uc0V3IC9mLuRn9pwugv2SoGdNf/ZQQMnvdHWmKC33pjnw
wbb/0udvwajqz9cGhS3EhZbkcqis7whs4qFoqWhDGUUFOZ1N3VFFSHrC2wqs/RrM
OEPJZ3mEYV/78Y/GBZIM8oTUeRKE8/yffn75n7yMmV2lhuCL36I2OqDtY0z5N2o7
oBPK0ezAX1YSiACjzUGnWuQwOvL10KTAQgnBCwEtfyCo3y2MwuRPoeAU948p+570
+RftYbKy1vmsdNj8oFyr
=pp4a
-----END PGP SIGNATURE-----

--c4ATLI8HJzklxeaH--