Downloads
Home   >   mailing lists

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

From Nathan Bossart
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id aHpwsGXSicLArZSk@nathan
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
Tree view 
Committed.

I'm cautiously optimistic that we can find some better gains for upgrades
from v16 and newer.  That would involve dumping lo_create() commands for
all LOs with comments/seclabels, dumping the relevant pg_shdepend rows, and
then copying/linking the pg_largeobject_metadata files like we did prior to
v12.

-- 
nathan

pgsql-hackers by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table
Next
From: Andres Freund
Date:
Subject: Re: Making type Datum be 8 bytes everywhere