Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 - Mailing list pgsql-general

From Vick Khera
Subject Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2
Date
Msg-id CALd+dcdcG+oJLbUh7fPxkDb2cWxiEV2CYD9scS1wz1y0zhseyg@mail.gmail.com
Whole thread Raw
In response to Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On Sun, Sep 4, 2016 at 4:37 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
> That's great news! My only concern is about the "RSYNC" - Hope that doesn't
> take long!!!
>
> This all steps must be performed by me on the next few days/weeks - I'll
> keep you guys updated... Keen to see the new DB running in a SSD environment
> :)

That will depend on your database change velocity. If the initial copy
takes a long time, Re-run the rsync again just before the shut down.
Try to pick the lowest load time.

For sure rsync can take a long time. I've also done similar moves
using ZFS snapshots, which are crazy fast to sync... but that assumes
you're using ZFS already on the current data directory.


pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Check if there 6 last records of same type without gaps
Next
From: Nicolas Grilly
Date:
Subject: Re: Clustered index to preserve data locality in a multitenant application?