Re: alter column type - Mailing list pgsql-general

From Casey Deccio
Subject Re: alter column type
Date
Msg-id CAEKtLiQ5b_bBrFbCESO87ukqvDMaSO-ySYBgj2Sp5pNJWFpsJQ@mail.gmail.com
Whole thread Raw
In response to Re: alter column type  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Fri, Jun 5, 2015 at 4:00 PM, John R Pierce <pierce@hogranch.com> wrote:
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

 
Actually, there are six in four different tables.

But... I didn't know I could combine multiple ALTERs into a single statement.  Thanks for the heads up.

Casey

pgsql-general by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1