Re: Gradual migration from integer to bigint? - Mailing list pgsql-general

From Ron
Subject Re: Gradual migration from integer to bigint?
Date
Msg-id db2b2a3b-3681-d052-7ce5-472027ffa404@gmail.com
Whole thread Raw
In response to Re: Gradual migration from integer to bigint?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Gradual migration from integer to bigint?
Next
From: pf@pfortin.com
Date:
Subject: Re: cache lookup failed for function 0