Hi Kevin,
This sounds like a good idea, I will work hard on this idea and let you
know the result.
Most appreciated.
Kevin Brannen 于2020年12月5日周六 上午12:04写道：
> *>From:* Olivier Gautherot
>
> >>5) If you're brave enough, convert your current table as a partition
> (rename it to something like ta
Hi Olivier,
My PG version is 10.
Anyway, thanks a lot for your help.
Best regards.
Olivier Gautherot 于2020年12月4日周五 下午6:14写道：
> Hi Charles,
> On 04-12-2020 9:44, Olivier Gautherot wrote:
>
> Hi Charles,
>
> On Fri, Dec 4, 2020 at 9:12 AM charles meng wrote:
>
>>
.
>
> On Thu, Dec 3, 2020, 7:11 PM charles meng wrote:
>
>> Thanks for your help, I think the first method I tried (adding temporary
>> column) is similar to what you said, but it takes too much time for me.
>>
>>
>> Thanks again.
>>
>> Michael L
Hi all,
I have a table with 1.6 billion records. The data type of the primary key
column is incorrectly used as integer. I need to replace the type of the
column with bigint. Is there any ideas for this?
Solutions that have been tried:
Adding temporary columns was too time-consuming, so I gave up
