Re: alter column type

From: Ravi Krishna <sravikrishna3(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Casey Deccio <casey(at)deccio(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: alter column type
Date: 2015-06-05 18:37:54
Message-ID: CACER=P2XUexK7cw0pzNSoQHHAiLb0pZ-rMB9x2EBATV2AFypEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sheena, Prabhjot 2015-06-05 18:38:13 Re: Query running slow for only one specific id. (Postgres 9.3) version
Previous Message Alvaro Herrera 2015-06-05 18:36:30 Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1