Postgres Pro
Downloads
Home   >   mailing lists

V12 to V16 Upgrade -- does size matters? - Mailing list pgsql-admin

From Edwin UY
Subject V12 to V16 Upgrade -- does size matters?
Date
Msg-id CA+wokJ9gRskQ2Wy3wyA6XxWNvHnAPDD+_NvCSpDEbftY6BVdTQ@mail.gmail.com
Whole thread Raw
Responses Re: V12 to V16 Upgrade -- does size matters?
List pgsql-admin
Tree view
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.



pgsql-admin by date:

Previous
From: Mark Smith
Date:
Subject: Re: Changing the Datatype from Bit to Boolean.
Next
From: Ron Johnson
Date:
Subject: Re: V12 to V16 Upgrade -- does size matters?