Re: Gradual migration from integer to bigint?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Gradual migration from integer to bigint?
Date: 2023-10-01 04:26:14
Message-ID: db2b2a3b-3681-d052-7ce5-472027ffa404@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/30/23 22:37, Tom Lane wrote:
[snip]
> especially not a break that adds more per-row overhead.
>
> So really the only way forward for this would be to provide more
> automation for the existing conversion processes involving table
> rewrites.

When altering an unindexed INT to BIGINT, do all of the indices get rewritten?

--
Born in Arizona, moved to Babylonia.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pf 2023-10-01 05:57:59 Re: cache lookup failed for function 0
Previous Message Tom Lane 2023-10-01 03:37:27 Re: Gradual migration from integer to bigint?