Postgres Pro
Downloads
Home   >   mailing lists

Re: alter column type - Mailing list pgsql-general

From John R Pierce
Subject Re: alter column type
Date
Msg-id 5571FFD6.7090401@hogranch.com
Whole thread Raw
In response to Re: alter column type  (Casey Deccio <casey@deccio.net>)
Responses Re: alter column type  (Casey Deccio <casey@deccio.net>)
List pgsql-general
Tree view
On 6/5/2015 11:46 AM, Casey Deccio wrote:
On Fri, Jun 5, 2015 at 2:36 PM, Michael Nolan <htfoot@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 :)


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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter column type
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1