Обсуждение: robust way of moving tables to a different disk??

Поиск
Список
Период
Сортировка

robust way of moving tables to a different disk??

От
Sam Mortimer
Дата:
Hello,

I'd like to move some tables from a particular database onto a different set
of disks.  However, I can't see any robust way of achieving this.  I've
tried using symlinks but these can easily be broken by a mixture of "vacuum
full" and growing the table again (assuming the table is large enough to
span multiple files).  We can handle a solution that breaks when the table
is dropped and recreated, that's a special enough case enough to be managed.

Any ideas welcome!

Regards,
-Sam.