V12 to V16 Upgrade -- does size matters?

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: V12 to V16 Upgrade -- does size matters?
Date: 2025-02-25 04:47:37
Message-ID: CA+wokJ9gRskQ2Wy3wyA6XxWNvHnAPDD+_NvCSpDEbftY6BVdTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Does size matter when doing the upgrade?
Just noted the non-PROD database is 20G and the PROD one is around 500G.
Does the size of the database affect how long the upgrade will finish?
Especially when running the ANALYZE post-upgrade.
FYI, more than half of the 500G are pg_toast.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-02-25 05:18:26 Re: V12 to V16 Upgrade -- does size matters?
Previous Message Mark Smith 2025-02-24 23:54:33 Re: Changing the Datatype from Bit to Boolean.