Search Postgresql Archives

Re: Gradual migration from integer to bigint?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, 1 Oct 2023 at 04:35, Bruce Momjian <bruce@xxxxxxxxxx> wrote:
> I think this talk will help you:
>
>         https://www.youtube.com/watch?v=XYRgTazYuZ4

Thanks, I hadn't seen that talk and it's a good summary of the issue
and available solutions.

However it doesn't really address the question of a gradual migration
process that can read 32bit ints but insert/update as 64bit bigints. I
remain curious about whether the postgres architecture just makes that
implausible, or if it could be done and just hasn't because the
options for a more manual migration are Good Enough.

James





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux