Re: Horribly slow pg_upgrade performance with many Large Objects - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id 4047312.1744130263@sss.pgh.pa.us
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Hannu Krosing <hannuk@google.com>)
Responses Re: Horribly slow pg_upgrade performance with many Large Objects
Re: Horribly slow pg_upgrade performance with many Large Objects
List pgsql-hackers
Hannu Krosing <hannuk@google.com> writes:
> I think we do preserve role oids

Oh ... I'd been looking for mentions of "role" in
pg_upgrade_support.c, but what I should have looked for was
"pg_authid".  So yeah, we do preserve role OIDs, and maybe that's
enough to make this workable, at least with source versions that
share the same rules for what goes into pg_largeobject_metadata and
pg_shdepend.  It's not something I'd risk back-patching though.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Wolfgang Walther
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Nico Williams
Date:
Subject: Re: Feature freeze