Re: alter column type

From: Ravi Krishna <sravikrishna3(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: alter column type
Date: 2015-06-05 19:20:40
Message-ID: CACER=P37-upWMG-HGdfmK=piNXNVrY1QhnbFjC0reL1aicXDCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> In the above case PG will simply do a dictionary update of meta
> tables. So all new rows will reflect col-T and as and when the old

I will clarify it bit further:

All new rows will have space allocated for col-T and no space
allocated for col-S, while existing dormant rows are left unmodified .

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2015-06-05 19:28:23 Re: Re: Query running slow for only one specific id. (Postgres 9.3) version
Previous Message Ravi Krishna 2015-06-05 19:18:28 Re: alter column type