Postgres Pro
Downloads
Home   >   mailing lists

Postgres upgrade 12 - issues with OIDs - Mailing list pgsql-general

From Venkata B Nagothi
Subject Postgres upgrade 12 - issues with OIDs
Date
Msg-id CAEyp7J-zwbRqR7P64ik6VmO1fqYa4z-QwfQVnNP7LcxDA3XwKA@mail.gmail.com
Whole thread Raw
Responses Re: Postgres upgrade 12 - issues with OIDs
List pgsql-general
Tree view
Hi There,

We are attempting to upgrade our Postgres databases from 9.5 to 12.5 using pg_upgrade link mode and are facing issues with OIDs.

ALTER TABLE... SET WITHOUT OIDs on the larger tables is taking very long and is locking up the table as well. We do have tables of more than 1 TB of size. 
Is there any way to make this complete faster ?  Any suggestions would be great. 

Regards,

Venkata B N
Database Consultant
 

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Extended stats - value not in MCV list
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres upgrade 12 - issues with OIDs