Re: alter column type

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 05 Jun 2015 13:00:22 -0700



    On 6/5/2015 11:46 AM, Casey Deccio
      wrote:

    
    On Fri, Jun 5, 2015 at 2:36 PM, Michael Nolan <htfoot@xxxxxxxxx>
      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