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