| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 |
| Date: | 2016-09-06 15:51:22 |
| Message-ID: | CALd+dcdcG+oJLbUh7fPxkDb2cWxiEV2CYD9scS1wz1y0zhseyg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Sep 4, 2016 at 4:37 PM, Patrick B <patrickbakerbr(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Grilly | 2016-09-06 16:21:33 | Re: Clustered index to preserve data locality in a multitenant application? |
| Previous Message | Alexander Farber | 2016-09-06 13:38:24 | Re: Check if there 6 last records of same type without gaps |