Re: Speed of conversion from int to bigint

From: George Neuner <gneuner2(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Speed of conversion from int to bigint
Date: 2017-09-27 10:06:07
Message-ID: rqtmsc9qiosfh6014i9jh3bk7ag5788p8f@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tomas's suggestion definitely is the better if you're altering the
type of a single column. If you need to make more extensive changes
to the table structure, copying usually is the better way to go.

George

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-09-27 16:59:40 Re: Catching errors inside a LOOP is causing performance issues
Previous Message George Neuner 2017-09-27 09:49:25 Re: Speed of conversion from int to bigint