From: | Mohamed Wael Khobalatte <mkhobalatte(at)grubhub(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Michael Lewis <mlewis(at)entrata(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Switching Primary Keys to BigInt |
Date: | 2020-07-22 01:08:03 |
Message-ID: | CABZeWdwbTqGFPUoamjfMWk46=isZe-f_pNX4_NiSNMv5v1u6Ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Yeah, I thought the int --> bigint would not do a table rewrite. Testing
> showed otherwise. Forget that idea.
Got it. Not sure what else we should consider. It seemed like the
constraint might be possible, but currently need a far bigger table to be
able to tell for sure, since we can't explain a DDL.
On Tue, Jul 21, 2020 at 7:32 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 7/21/20 2:18 PM, Mohamed Wael Khobalatte wrote:
> >> > test_(aklaver)5432> alter table change_seq alter COLUMN id set data
> type
> >> bigint;
> >> ALTER TABLE
> >> test_(aklaver)5432> \d change_seq
> >> Table "public.change_seq"
> >> Column | Type | Collation | Nullable | Default
> >>
> --------+--------+-----------+----------+----------------------------------------
> >>
> >> id | bigint | | not null |
> >> nextval('change_seq_id_seq'::regclass)
> >> Indexes:
> >> "change_seq_pkey" PRIMARY KEY, btree (id)
> >
> > This is significant downtime, since it locks exclusively, no? We want to
> > avoid that.
>
> Yeah, I thought the int --> bigint would not do a table rewrite. Testing
> showed otherwise. Forget that idea.
>
> >
> > > Side note- EOL for 9.6 is coming next year so just a plug for
> > upgrading when possible, perhaps utilizing pglogical to get to v11 or 12.
> >
> > Yep, we are painfully aware. The id growth will beat us to it, so we
> > need to deal with that first.
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Nelson | 2020-07-22 02:30:21 | CASCADE/fkey order |
Previous Message | Adrian Klaver | 2020-07-21 23:32:40 | Re: Switching Primary Keys to BigInt |