Re: alter column type

On 6/5/2015 11:46 AM, Casey Deccio wrote:
> On Fri, Jun 5, 2015 at 2:36 PM, Michael Nolan <htfoot(at)gmail(dot)com
> <mailto:htfoot(at)gmail(dot)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 :)

if all 5 alters' were to the same table, you should have combined them
into one alter statement.

--
john r pierce, recycling bits in santa cruz