Re: alter column type - Mailing list pgsql-general

From Ravi Krishna
Subject Re: alter column type
Date
Msg-id CACER=P2XUexK7cw0pzNSoQHHAiLb0pZ-rMB9x2EBATV2AFypEQ@mail.gmail.com
Whole thread Raw
In response to Re: alter column type  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: alter column type  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Why is PG even re-writing all rows when the data type is being changed
from smaller (int) to larger (bigint) type, which automatically means
existing data is safe. Like, changing from varchar(30) to varchar(50)
should involve no rewrite of existing rows.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Next
From: "Sheena, Prabhjot"
Date:
Subject: Re: Query running slow for only one specific id. (Postgres 9.3) version