On Fri, Jun 5, 2015 at 2:36 PM, Michael Nolan <htf...@gmail.com> wrote:

>
> Probably too late for this time, but in the past when I've needed to
> redefine the type for a column, I've made a dump, edited the dump file to
> change the type and then renamed the table and reloaded it.  That's usually
> several orders of magnitude faster.
>

Actually, not too late.  My first ALTER is still running, and I still have
four more to go.  Sigh.  I had thought of this but wasn't sure how it might
compare.  Thanks for the data point :)

Casey

Reply via email to