change column data type of a big table

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: change column data type of a big table
Date: 2012-08-10 05:31:05
Message-ID: 001801cd76b9$588438a0$098ca9e0$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a very big table, in fact only this table uses approx. 60% space of
disk.

The table is an standalone table (no one inherit from this and this is not
inherit from another).

I need to change a int column to bigint.

But aparentely this alter recreate the table, my problem is the space, there
are no space enough in disk.

Is possible to change column datatype without recreating the table?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-08-10 06:05:23 Re: change column data type of a big table
Previous Message Theron Luhn 2012-08-09 20:57:25 Full-text search: Problems with dictionaries and periods