Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
Quick Links
Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites
大表修改字段类型
From:
charles meng <xlyybz(at)gmail(dot)com>
To:
pgsql-zh-general(at)lists(dot)postgresql(dot)org
Subject:
大表修改字段类型
Date:
2020-12-03 05:28:55
Message-ID:
CAD5cqMKZFqaYjEboutMAdDR9Y4pa=P=azg2o6gmfyGMikVkKJA@mail.gmail.com
Views:
Raw Message
|
Whole Thread
|
Download mbox
|
Resend email
Thread:
2020-12-03 05:28:55 from charles meng <xlyybz(at)gmail(dot)com>
2020-12-04 00:56:34 from Huang Bambo <bambo(dot)huang(at)gmail(dot)com>
Lists:
pgsql-zh-general
各位好:
由于历史原因,我们有张表已经有16亿的数据量了,并且主键使用的是integer类型,很快就会达到该类型的最大值;
现在需要将该字段调整为bigint,请问有什么好的方案吗?
提前感谢
Responses
Re: 大表修改字段类型
at 2020-12-04 00:56:34 from Huang Bambo
Browse pgsql-zh-general by date
From
Date
Subject
Next Message
Huang Bambo
2020-12-04 00:56:34
Re: 大表修改字段类型
Previous Message
彭煜玮
2019-12-27 09:55:28
Re: 中文翻译还有需求吗?