Re: Upgrade from PG12 to PG - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Upgrade from PG12 to PG
Date
Msg-id a0a7dceb61ab4ae3b2178566684fd3bdf087e698.camel@cybertec.at
Whole thread Raw
In response to Re: Upgrade from PG12 to PG  (Jef Mortelle <jefmortelle@gmail.com>)
Responses Re: Upgrade from PG12 to PG
List pgsql-admin
On Thu, 2023-07-20 at 15:46 +0200, Jef Mortelle wrote:
> So: not possible to have very little downtime if you have a database
> with al lot rows containing text  as datatype, as pg_upgrade needs 12hr
> for 24 milj rows in pg_largeobject.

To clarify: "text" is no problem at all.  Large objects are.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Re: How to schedule long running SQL job
Next
From: Jef Mortelle
Date:
Subject: Re: Upgrade from PG12 to PG