Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2
Дата
Msg-id CALd+dcdcG+oJLbUh7fPxkDb2cWxiEV2CYD9scS1wz1y0zhseyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: Check if there 6 last records of same type without gaps
Следующее
От: Nicolas Grilly
Дата:
Сообщение: Re: Clustered index to preserve data locality in a multitenant application?