Postgres Pro
Downloads
Home   >   mailing lists

Re: change bigint column to int - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: change bigint column to int
Date
Msg-id CAGDYbUP9J9EuKWyYxF9UA_xiKjsoewQmADKHCt8ywYPqY7vt=g@mail.gmail.com
Whole thread Raw
In response to change bigint column to int  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: change bigint column to int  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Tree view
Hi Mariel,

After changing the column bigint to int size get reduced.

But it has two huge and interrelated problems: locking and time. This approach locks the table for as long as the command takes to run. And by lock, taking a heavy “access exclusive” lock which shuts everything else out of the table. If your table is small, this is not an issue.




On Thu, Nov 1, 2018 at 3:51 PM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
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: Mariel Cherkassky
Date:
Subject: change bigint column to int
Next
From: Mariel Cherkassky
Date:
Subject: Re: change bigint column to int