Re: change bigint column to int
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 по дате отправления: