Postgres Pro
Downloads
Home   >   mailing lists

Re: alter column type - Mailing list pgsql-general

From Ravi Krishna
Subject Re: alter column type
Date
Msg-id CACER=P37-upWMG-HGdfmK=piNXNVrY1QhnbFjC0reL1aicXDCQ@mail.gmail.com
Whole thread Raw
In response to Re: alter column type  (Ravi Krishna <sravikrishna3@gmail.com>)
List pgsql-general
Tree view 
> 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 .

pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: alter column type
Next
From: Steve Crawford
Date:
Subject: Re: Re: Query running slow for only one specific id. (Postgres 9.3) version