Re: Upgrade questions

On 03/13/12 6:10 PM, Carson Gross wrote:
> As a follow up, is the upgrade from integer to bigint violent?  I
> assume so: it has to physically resize the column on disk, right?
>

I think we've said several times, any ALTER TABLE ADD/ALTER COLUMN like
that will cause every single tuple (row) of the table to be updated.
when rows are updated, the new row is written, then the old row is
flagged for eventual vacuuming.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast