Postgres Pro
Downloads
Home   >   mailing lists

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

From Mariel Cherkassky
Subject Re: change bigint column to int
Date
Msg-id CA+t6e1mBZDs34MZt7jb01S09DwW9Lwqha--+5bSQmDCss8zXbg@mail.gmail.com
Whole thread Raw
In response to Re: change bigint column to int  (Evan Bauer <evanbauer@mac.com>)
Responses Re: change bigint column to int  (Evan Bauer <evanbauer@mac.com>)
List pgsql-admin
Tree view
I want to do it on a very big tables(100M records). Do you think that it will be slow ? I mean if I have an AccessExclusiveLock for a lot of time I cant just run a query and take my time until it finishes.. 

‫בתאריך יום ה׳, 1 בנוב׳ 2018 ב-13:55 מאת ‪Evan Bauer‬‏ <‪evanbauer@mac.com‬‏>:‬
Mariel,

Just run a query and make certain that all values currently stored in the column fit in 4 bytes (+/- 2,147,483,648) before doing the ALTER.

Cheers,

Evan

Sent from my iPhone

On Nov 1, 2018, at 06:20, 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: Evan Bauer
Date:
Subject: Re: change bigint column to int
Next
From: Evan Bauer
Date:
Subject: Re: change bigint column to int