Postgres Pro
Downloads
Home   >   mailing lists

change bigint column to int - Mailing list pgsql-admin

From Mariel Cherkassky
Subject change bigint column to int
Date
Msg-id CA+t6e1nSubJm8pJ4WsKpR_HHiNsLPtCLLGDzMNQLcXwhYgijkA@mail.gmail.com
Whole thread Raw
Responses Re: change bigint column to int  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: change bigint column to int  (Evan Bauer <evanbauer@mac.com>)
List pgsql-admin
Tree view
Hi,

I want to change the column type from bigint to int to save space. By doing so, does it include some risks ? As I see it, I should only run vacuum full afterwards if I want to return space to the os right ?

pgsql-admin by date:

Previous
From: Lalith Tenneti
Date:
Subject: Fwd: ALTER PUBLICATION
Next
From: Shreeyansh Dba
Date:
Subject: Re: change bigint column to int