From: Jerry Sievers <gsievers19@comcast.net>
To: Stephen Frost <sfrost@snowman.net>
Cc: Jerry Sievers <gsievers19@comcast.net>,  pgsql-admin@postgresql.org
Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
References: <86d1m5b6bi.fsf@jerry.enova.com>
	<20160725163700.GZ4028@tamriel.snowman.net>
	<20160725164329.GA4028@tamriel.snowman.net>
Date: Mon, 25 Jul 2016 12:34:45 -0500
In-Reply-To: <20160725164329.GA4028@tamriel.snowman.net> (Stephen Frost's
	message of "Mon, 25 Jul 2016 12:43:29 -0400")
Message-ID: <86eg6hr58q.fsf@jerry.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Stephen Frost <sfrost@snowman.net> writes:

> * Stephen Frost (sfrost@snowman.net) wrote:
>
>> > I have among others, a 5TB system  w/about 40G of unlogged data.
>> 
>> 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. :)

Roger that!  Really, the hard link pg-upgrade option and rsync method
for standbys is pure beauty :-)

We have only the post-analyze and this unlogged data  problem to deal
with. 

The warehouse is our only system with any substantial amount of unlogged
data.

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.

Thanks!

> Depends on your network speed if the 40G would be an issue or not then.
> In some cases, it might only add a bit of time but keep the process
> simple, other cases, it might take longer.  I'm not really thrilled with
> the idea of complicating the rsync in that way, but I can understand why
> you're considering it.
>
> Thanks!
>
> Stephen

-- 
Jerry Sievers
e: jerry.sievers@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin